Report

Dataset statistics

Number of variables	47
Number of observations	2845342
Missing cells	3414349
Missing cells (%)	2.6%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	773.4 MiB
Average record size in memory	285.0 B

Variable types

Categorical	21
Numeric	13
Boolean	13

Alerts

`Country` has constant value "US"	Constant
`Turning_Loop` has constant value "False"	Constant
`ID` has a high cardinality: 2845342 distinct values	High cardinality
`Start_Time` has a high cardinality: 1959333 distinct values	High cardinality
`End_Time` has a high cardinality: 2351505 distinct values	High cardinality
`Description` has a high cardinality: 1174563 distinct values	High cardinality
`Street` has a high cardinality: 159651 distinct values	High cardinality
`City` has a high cardinality: 11681 distinct values	High cardinality
`County` has a high cardinality: 1707 distinct values	High cardinality
`Zipcode` has a high cardinality: 363085 distinct values	High cardinality
`Airport_Code` has a high cardinality: 2004 distinct values	High cardinality
`Weather_Timestamp` has a high cardinality: 474214 distinct values	High cardinality
`Weather_Condition` has a high cardinality: 127 distinct values	High cardinality
`Start_Lat` is highly correlated with `End_Lat`	High correlation
`Start_Lng` is highly correlated with `End_Lng`	High correlation
`End_Lat` is highly correlated with `Start_Lat`	High correlation
`End_Lng` is highly correlated with `Start_Lng`	High correlation
`Temperature(F)` is highly correlated with `Wind_Chill(F)`	High correlation
`Wind_Chill(F)` is highly correlated with `Temperature(F)`	High correlation
`Bump` is highly correlated with `Traffic_Calming`	High correlation
`Traffic_Calming` is highly correlated with `Bump`	High correlation
`Start_Lat` is highly correlated with `End_Lat` and 1 other fields	High correlation
`Start_Lng` is highly correlated with `End_Lng`	High correlation
`End_Lat` is highly correlated with `Start_Lat` and 1 other fields	High correlation
`End_Lng` is highly correlated with `Start_Lng`	High correlation
`Temperature(F)` is highly correlated with `Wind_Chill(F)`	High correlation
`Wind_Chill(F)` is highly correlated with `Start_Lat` and 2 other fields	High correlation
`Bump` is highly correlated with `Traffic_Calming`	High correlation
`Traffic_Calming` is highly correlated with `Bump`	High correlation
`Start_Lat` is highly correlated with `End_Lat`	High correlation
`Start_Lng` is highly correlated with `End_Lng`	High correlation
`End_Lat` is highly correlated with `Start_Lat`	High correlation
`End_Lng` is highly correlated with `Start_Lng`	High correlation
`Temperature(F)` is highly correlated with `Wind_Chill(F)`	High correlation
`Wind_Chill(F)` is highly correlated with `Temperature(F)`	High correlation
`Bump` is highly correlated with `Traffic_Calming`	High correlation
`Traffic_Calming` is highly correlated with `Bump`	High correlation
`Give_Way` is highly correlated with `Turning_Loop` and 1 other fields	High correlation
`State` is highly correlated with `Turning_Loop` and 2 other fields	High correlation
`Severity` is highly correlated with `Turning_Loop` and 1 other fields	High correlation
`Civil_Twilight` is highly correlated with `Turning_Loop` and 4 other fields	High correlation
`Side` is highly correlated with `Turning_Loop` and 1 other fields	High correlation
`Bump` is highly correlated with `Turning_Loop` and 2 other fields	High correlation
`Crossing` is highly correlated with `Turning_Loop` and 1 other fields	High correlation
`Railway` is highly correlated with `Turning_Loop` and 1 other fields	High correlation
`Amenity` is highly correlated with `Turning_Loop` and 1 other fields	High correlation
`Stop` is highly correlated with `Turning_Loop` and 1 other fields	High correlation
`Turning_Loop` is highly correlated with `Give_Way` and 21 other fields	High correlation
`Nautical_Twilight` is highly correlated with `Civil_Twilight` and 4 other fields	High correlation
`Junction` is highly correlated with `Turning_Loop` and 1 other fields	High correlation
`Wind_Direction` is highly correlated with `Turning_Loop` and 1 other fields	High correlation
`Roundabout` is highly correlated with `Turning_Loop` and 1 other fields	High correlation
`Traffic_Calming` is highly correlated with `Bump` and 2 other fields	High correlation
`Astronomical_Twilight` is highly correlated with `Civil_Twilight` and 4 other fields	High correlation
`No_Exit` is highly correlated with `Turning_Loop` and 1 other fields	High correlation
`Sunrise_Sunset` is highly correlated with `Civil_Twilight` and 4 other fields	High correlation
`Traffic_Signal` is highly correlated with `Turning_Loop` and 1 other fields	High correlation
`Station` is highly correlated with `Turning_Loop` and 1 other fields	High correlation
`Timezone` is highly correlated with `State` and 2 other fields	High correlation
`Country` is highly correlated with `Give_Way` and 21 other fields	High correlation
`Start_Lat` is highly correlated with `Start_Lng` and 5 other fields	High correlation
`Start_Lng` is highly correlated with `Start_Lat` and 4 other fields	High correlation
`End_Lat` is highly correlated with `Start_Lat` and 5 other fields	High correlation
`End_Lng` is highly correlated with `Start_Lat` and 4 other fields	High correlation
`State` is highly correlated with `Start_Lat` and 6 other fields	High correlation
`Timezone` is highly correlated with `Start_Lat` and 4 other fields	High correlation
`Temperature(F)` is highly correlated with `Wind_Chill(F)`	High correlation
`Wind_Chill(F)` is highly correlated with `Start_Lat` and 3 other fields	High correlation
`Pressure(in)` is highly correlated with `State`	High correlation
`Bump` is highly correlated with `Traffic_Calming`	High correlation
`Crossing` is highly correlated with `Traffic_Signal`	High correlation
`Traffic_Calming` is highly correlated with `Bump`	High correlation
`Traffic_Signal` is highly correlated with `Crossing`	High correlation
`Sunrise_Sunset` is highly correlated with `Civil_Twilight` and 2 other fields	High correlation
`Civil_Twilight` is highly correlated with `Sunrise_Sunset` and 2 other fields	High correlation
`Nautical_Twilight` is highly correlated with `Sunrise_Sunset` and 2 other fields	High correlation
`Astronomical_Twilight` is highly correlated with `Sunrise_Sunset` and 2 other fields	High correlation
`Number` has 1743911 (61.3%) missing values	Missing
`Weather_Timestamp` has 50736 (1.8%) missing values	Missing
`Temperature(F)` has 69274 (2.4%) missing values	Missing
`Wind_Chill(F)` has 469643 (16.5%) missing values	Missing
`Humidity(%)` has 73092 (2.6%) missing values	Missing
`Pressure(in)` has 59200 (2.1%) missing values	Missing
`Visibility(mi)` has 70546 (2.5%) missing values	Missing
`Wind_Direction` has 73775 (2.6%) missing values	Missing
`Wind_Speed(mph)` has 157944 (5.6%) missing values	Missing
`Precipitation(in)` has 549458 (19.3%) missing values	Missing
`Weather_Condition` has 70636 (2.5%) missing values	Missing
`Number` is highly skewed (γ1 = 156.9450181)	Skewed
`Precipitation(in)` is highly skewed (γ1 = 106.2589449)	Skewed
`ID` is uniformly distributed	Uniform
`End_Time` is uniformly distributed	Uniform
`ID` has unique values	Unique
`Distance(mi)` has 385441 (13.5%) zeros	Zeros
`Wind_Speed(mph)` has 433636 (15.2%) zeros	Zeros
`Precipitation(in)` has 2104242 (74.0%) zeros	Zeros

Reproduction

Analysis started	2022-05-28 08:50:38.659229
Analysis finished	2022-05-28 09:19:30.860048
Duration	28 minutes and 52.2 seconds
Software version	pandas-profiling v3.2.0
Download configuration	config.json

ID
Categorical

HIGH CARDINALITY
UNIFORM
UNIQUE

Distinct	2845342
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	21.7 MiB

A-1	1
A-1896898	1
A-1896890	1
A-1896891	1
A-1896892	1
Other values (2845337)	2845337

Length

Max length	9
Median length	9
Mean length	8.609500721
Min length	3

Characters and Unicode

Total characters	24496974
Distinct characters	12
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2845342 ?
Unique (%)	100.0%

Sample

1st row	A-1
2nd row	A-2
3rd row	A-3
4th row	A-4
5th row	A-5

Common Values

Value	Count	Frequency (%)
A-1	1	< 0.1%
A-1896898	1	< 0.1%
A-1896890	1	< 0.1%
A-1896891	1	< 0.1%
A-1896892	1	< 0.1%
A-1896893	1	< 0.1%
A-1896894	1	< 0.1%
A-1896895	1	< 0.1%
A-1896896	1	< 0.1%
A-1896897	1	< 0.1%
Other values (2845332)	2845332	> 99.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
a-1	1	< 0.1%
a-6	1	< 0.1%
a-42	1	< 0.1%
a-24	1	< 0.1%
a-22	1	< 0.1%
a-86	1	< 0.1%
a-11	1	< 0.1%
a-3	1	< 0.1%
a-4	1	< 0.1%
a-5	1	< 0.1%
Other values (2845332)	2845332	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
A	2845342	11.6%
-	2845342	11.6%
1	2728675	11.1%
2	2574018	10.5%
3	1728617	7.1%
4	1723910	7.0%
5	1717907	7.0%
6	1717564	7.0%
7	1717564	7.0%
8	1662907	6.8%
Other values (2)	3235128	13.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	18806290	76.8%
Uppercase Letter	2845342	11.6%
Dash Punctuation	2845342	11.6%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	2728675	14.5%
2	2574018	13.7%
3	1728617	9.2%
4	1723910	9.2%
5	1717907	9.1%
6	1717564	9.1%
7	1717564	9.1%
8	1662907	8.8%
9	1617564	8.6%
0	1617564	8.6%

Uppercase Letter

Value	Count	Frequency (%)
A	2845342	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	2845342	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	21651632	88.4%
Latin	2845342	11.6%

Most frequent character per script

Common

Value	Count	Frequency (%)
-	2845342	13.1%
1	2728675	12.6%
2	2574018	11.9%
3	1728617	8.0%
4	1723910	8.0%
5	1717907	7.9%
6	1717564	7.9%
7	1717564	7.9%
8	1662907	7.7%
9	1617564	7.5%

Latin

Value	Count	Frequency (%)
A	2845342	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	24496974	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	2845342	11.6%
-	2845342	11.6%
1	2728675	11.1%
2	2574018	10.5%
3	1728617	7.1%
4	1723910	7.0%
5	1717907	7.0%
6	1717564	7.0%
7	1717564	7.0%
8	1662907	6.8%
Other values (2)	3235128	13.2%

Severity
Categorical

HIGH CORRELATION

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	21.7 MiB

2	2532991
3	155105
4	131193
1	26053

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	2845342
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	3
2nd row	2
3rd row	2
4th row	2
5th row	3

Common Values

Value	Count	Frequency (%)
2	2532991	89.0%
3	155105	5.5%
4	131193	4.6%
1	26053	0.9%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
2	2532991	89.0%
3	155105	5.5%
4	131193	4.6%
1	26053	0.9%

Most occurring characters

Value	Count	Frequency (%)
2	2532991	89.0%
3	155105	5.5%
4	131193	4.6%
1	26053	0.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	2845342	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	2532991	89.0%
3	155105	5.5%
4	131193	4.6%
1	26053	0.9%

Most occurring scripts

Value	Count	Frequency (%)
Common	2845342	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	2532991	89.0%
3	155105	5.5%
4	131193	4.6%
1	26053	0.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2845342	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	2532991	89.0%
3	155105	5.5%
4	131193	4.6%
1	26053	0.9%

Start_Time
Categorical

HIGH CARDINALITY

Distinct	1959333
Distinct (%)	68.9%
Missing	0
Missing (%)	0.0%
Memory size	21.7 MiB

2021-01-26 16:16:13	214
2021-01-26 16:17:33	150
2021-02-16 06:42:43	130
2021-05-03 06:29:42	92
2021-04-26 08:58:47	87
Other values (1959328)	2844669

Length

Max length	29
Median length	19
Mean length	19.97513621
Min length	19

Characters and Unicode

Total characters	56836094
Distinct characters	14
Distinct categories	4 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1474489 ?
Unique (%)	51.8%

Sample

1st row	2016-02-08 00:37:08
2nd row	2016-02-08 05:56:20
3rd row	2016-02-08 06:15:39
4th row	2016-02-08 06:51:45
5th row	2016-02-08 07:53:43

Common Values

Value	Count	Frequency (%)
2021-01-26 16:16:13	214	< 0.1%
2021-01-26 16:17:33	150	< 0.1%
2021-02-16 06:42:43	130	< 0.1%
2021-05-03 06:29:42	92	< 0.1%
2021-04-26 08:58:47	87	< 0.1%
2021-02-16 06:43:35	85	< 0.1%
2021-11-21 18:37:51	84	< 0.1%
2020-12-16 13:53:25	76	< 0.1%
2021-04-14 13:51:30	67	< 0.1%
2021-05-03 06:30:28	66	< 0.1%
Other values (1959323)	2844291	> 99.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2021-12-23	12904	0.2%
2021-12-17	11505	0.2%
2021-12-10	11014	0.2%
2021-12-15	10603	0.2%
2021-12-16	10362	0.2%
2021-12-14	10298	0.2%
2021-12-03	10282	0.2%
2021-12-30	10171	0.2%
2021-12-22	9785	0.2%
2021-12-07	9434	0.2%
Other values (151175)	5584326	98.1%

Most occurring characters

Value	Count	Frequency (%)
0	13777809	24.2%
2	8658816	15.2%
1	8255915	14.5%
-	5690684	10.0%
:	5690684	10.0%
	2845342	5.0%
3	2299501	4.0%
5	1906020	3.4%
4	1856694	3.3%
9	1436136	2.5%
Other values (4)	4418493	7.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	42327032	74.5%
Other Punctuation	5973036	10.5%
Dash Punctuation	5690684	10.0%
Space Separator	2845342	5.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	13777809	32.6%
2	8658816	20.5%
1	8255915	19.5%
3	2299501	5.4%
5	1906020	4.5%
4	1856694	4.4%
9	1436136	3.4%
6	1392070	3.3%
7	1390217	3.3%
8	1353854	3.2%

Other Punctuation

Value	Count	Frequency (%)
:	5690684	95.3%
.	282352	4.7%

Dash Punctuation

Value	Count	Frequency (%)
-	5690684	100.0%

Space Separator

Value	Count	Frequency (%)
	2845342	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	56836094	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	13777809	24.2%
2	8658816	15.2%
1	8255915	14.5%
-	5690684	10.0%
:	5690684	10.0%
	2845342	5.0%
3	2299501	4.0%
5	1906020	3.4%
4	1856694	3.3%
9	1436136	2.5%
Other values (4)	4418493	7.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	56836094	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	13777809	24.2%
2	8658816	15.2%
1	8255915	14.5%
-	5690684	10.0%
:	5690684	10.0%
	2845342	5.0%
3	2299501	4.0%
5	1906020	3.4%
4	1856694	3.3%
9	1436136	2.5%
Other values (4)	4418493	7.8%

End_Time
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	2351505
Distinct (%)	82.6%
Missing	0
Missing (%)	0.0%
Memory size	21.7 MiB

2021-11-22 08:00:00	88
2017-05-15 15:22:55	58
2019-10-26 09:14:51	47
2020-02-14 00:00:00	46
2020-02-12 00:00:00	42
Other values (2351500)	2845061

Length

Max length	29
Median length	19
Mean length	19.97513621
Min length	19

Characters and Unicode

Total characters	56836094
Distinct characters	14
Distinct categories	4 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2000679 ?
Unique (%)	70.3%

Sample

1st row	2016-02-08 06:37:08
2nd row	2016-02-08 11:56:20
3rd row	2016-02-08 12:15:39
4th row	2016-02-08 12:51:45
5th row	2016-02-08 13:53:43

Common Values

Value	Count	Frequency (%)
2021-11-22 08:00:00	88	< 0.1%
2017-05-15 15:22:55	58	< 0.1%
2019-10-26 09:14:51	47	< 0.1%
2020-02-14 00:00:00	46	< 0.1%
2020-02-12 00:00:00	42	< 0.1%
2020-01-25 00:00:00	41	< 0.1%
2021-02-13 16:45:00	39	< 0.1%
2020-02-15 00:00:00	38	< 0.1%
2020-02-07 00:00:00	38	< 0.1%
2020-02-11 00:00:00	37	< 0.1%
Other values (2351495)	2844868	> 99.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2021-12-23	12569	0.2%
2021-12-17	11473	0.2%
2021-12-10	10781	0.2%
2021-12-15	10619	0.2%
2021-12-16	10342	0.2%
2021-12-14	10307	0.2%
2021-12-30	10138	0.2%
2021-12-03	10092	0.2%
2021-12-22	9783	0.2%
2021-12-07	9500	0.2%
Other values (175401)	5585080	98.1%

Most occurring characters

Value	Count	Frequency (%)
0	12296795	21.6%
2	9101230	16.0%
1	8427131	14.8%
-	5690684	10.0%
:	5690684	10.0%
	2845342	5.0%
3	2452424	4.3%
5	2090696	3.7%
4	2067261	3.6%
9	1604270	2.8%
Other values (4)	4569577	8.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	42327032	74.5%
Other Punctuation	5973036	10.5%
Dash Punctuation	5690684	10.0%
Space Separator	2845342	5.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	12296795	29.1%
2	9101230	21.5%
1	8427131	19.9%
3	2452424	5.8%
5	2090696	4.9%
4	2067261	4.9%
9	1604270	3.8%
8	1467902	3.5%
7	1415879	3.3%
6	1403444	3.3%

Other Punctuation

Value	Count	Frequency (%)
:	5690684	95.3%
.	282352	4.7%

Dash Punctuation

Value	Count	Frequency (%)
-	5690684	100.0%

Space Separator

Value	Count	Frequency (%)
	2845342	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	56836094	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	12296795	21.6%
2	9101230	16.0%
1	8427131	14.8%
-	5690684	10.0%
:	5690684	10.0%
	2845342	5.0%
3	2452424	4.3%
5	2090696	3.7%
4	2067261	3.6%
9	1604270	2.8%
Other values (4)	4569577	8.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	56836094	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	12296795	21.6%
2	9101230	16.0%
1	8427131	14.8%
-	5690684	10.0%
:	5690684	10.0%
	2845342	5.0%
3	2452424	4.3%
5	2090696	3.7%
4	2067261	3.6%
9	1604270	2.8%
Other values (4)	4569577	8.0%

Start_Lat
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	1093618
Distinct (%)	38.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	36.24520054

Minimum	24.566027
Maximum	49.00058
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	21.7 MiB

Quantile statistics

Minimum	24.566027
5-th percentile	25.96125525
Q1	33.445174
median	36.098609
Q3	40.160243
95-th percentile	45.0898267
Maximum	49.00058
Range	24.434553
Interquartile range (IQR)	6.715069

Descriptive statistics

Standard deviation	5.36379746
Coefficient of variation (CV)	0.1479864197
Kurtosis	-0.5870620559
Mean	36.24520054
Median Absolute Deviation (MAD)	3.376716
Skewness	-0.1146398312
Sum	103129991.4
Variance	28.77032319
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
25.702455	348	< 0.1%
27.447751	302	< 0.1%
28.452192	285	< 0.1%
28.449924	268	< 0.1%
40.85306	255	< 0.1%
25.689146	254	< 0.1%
25.712548	238	< 0.1%
34.020212	235	< 0.1%
28.452939	231	< 0.1%
25.810617	227	< 0.1%
Other values (1093608)	2842699	99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
24.566027	1	< 0.1%
24.570087	1	< 0.1%
24.570222	1	< 0.1%
24.57033	1	< 0.1%
24.570584	1	< 0.1%
24.571202	3	< 0.1%
24.57124	1	< 0.1%
24.571308	1	< 0.1%
24.57131	1	< 0.1%
24.571536	1	< 0.1%

Value	Count	Frequency (%)
49.00058	1	< 0.1%
49.00056	1	< 0.1%
49.000269	1	< 0.1%
49.00026	1	< 0.1%
48.99951	1	< 0.1%
48.998445	3	< 0.1%
48.99838	1	< 0.1%
48.997457	1	< 0.1%
48.996539	1	< 0.1%
48.996014	1	< 0.1%

Start_Lng
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	1120365
Distinct (%)	39.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-97.11463289

Minimum	-124.548074
Maximum	-67.113167
Zeros	0
Zeros (%)	0.0%
Negative	2845342
Negative (%)	100.0%
Memory size	21.7 MiB

Quantile statistics

Minimum	-124.548074
5-th percentile	-122.32597
Q1	-118.0331125
median	-92.418076
Q3	-80.372431
95-th percentile	-74.174027
Maximum	-67.113167
Range	57.434907
Interquartile range (IQR)	37.6606815

Descriptive statistics

Standard deviation	18.31781912
Coefficient of variation (CV)	-0.1886205876
Kurtosis	-1.649460042
Mean	-97.11463289
Median Absolute Deviation (MAD)	15.437108
Skewness	-0.2388874032
Sum	-276324343.8
Variance	335.5424974
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-80.332105	348	< 0.1%
-81.400388	285	< 0.1%
-81.479136	268	< 0.1%
-80.382872	254	< 0.1%
-73.96011	248	< 0.1%
-80.382427	238	< 0.1%
-117.814998	235	< 0.1%
-81.400159	231	< 0.1%
-77.478828	218	< 0.1%
-82.573305	216	< 0.1%
Other values (1120355)	2842801	99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-124.548074	2	< 0.1%
-124.517744	1	< 0.1%
-124.511949	1	< 0.1%
-124.497585	1	< 0.1%
-124.497567	2	< 0.1%
-124.49747	1	< 0.1%
-124.497448	2	< 0.1%
-124.497438	1	< 0.1%
-124.49742	5	< 0.1%
-124.49741	1	< 0.1%

Value	Count	Frequency (%)
-67.113167	1	< 0.1%
-67.403551	1	< 0.1%
-67.48413	1	< 0.1%
-67.606864	1	< 0.1%
-67.606875	1	< 0.1%
-67.614387	1	< 0.1%
-67.626576	1	< 0.1%
-67.70337	1	< 0.1%
-67.739696	1	< 0.1%
-67.78734	1	< 0.1%

End_Lat
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	1080811
Distinct (%)	38.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	36.24532079

Minimum	24.566013
Maximum	49.075
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	21.7 MiB

Quantile statistics

Minimum	24.566013
5-th percentile	25.958574
Q1	33.446278
median	36.0979865
Q3	40.16104925
95-th percentile	45.0905195
Maximum	49.075
Range	24.508987
Interquartile range (IQR)	6.71477125

Descriptive statistics

Standard deviation	5.363872991
Coefficient of variation (CV)	0.1479880126
Kurtosis	-0.5870021244
Mean	36.24532079
Median Absolute Deviation (MAD)	3.3769205
Skewness	-0.1146570877
Sum	103130333.6
Variance	28.77113347
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
25.701774	755	< 0.1%
25.684322	709	< 0.1%
25.73316	589	< 0.1%
28.449928	586	< 0.1%
28.45019	581	< 0.1%
25.924771	576	< 0.1%
28.450015	567	< 0.1%
25.686252	548	< 0.1%
37.55119	525	< 0.1%
35.842775	522	< 0.1%
Other values (1080801)	2839384	99.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
24.566013	1	< 0.1%
24.570107	1	< 0.1%
24.57011	1	< 0.1%
24.57018	1	< 0.1%
24.57036	1	< 0.1%
24.570461	1	< 0.1%
24.57124	1	< 0.1%
24.57126	1	< 0.1%
24.571309	1	< 0.1%
24.571389	1	< 0.1%

Value	Count	Frequency (%)
49.075	1	< 0.1%
49.00214	1	< 0.1%
49.00076	3	< 0.1%
49.00056	1	< 0.1%
48.999922	1	< 0.1%
48.99928	1	< 0.1%
48.999157	1	< 0.1%
48.999132	1	< 0.1%
48.99899	1	< 0.1%
48.998901	2	< 0.1%

End_Lng
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	1105404
Distinct (%)	38.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-97.1143871

Minimum	-124.545748
Maximum	-67.109242
Zeros	0
Zeros (%)	0.0%
Negative	2845342
Negative (%)	100.0%
Memory size	21.7 MiB

Quantile statistics

Minimum	-124.545748
5-th percentile	-122.32599
Q1	-118.0333308
median	-92.417718
Q3	-80.373383
95-th percentile	-74.173778
Maximum	-67.109242
Range	57.436506
Interquartile range (IQR)	37.65994775

Descriptive statistics

Standard deviation	18.31763242
Coefficient of variation (CV)	-0.1886191426
Kurtosis	-1.649469867
Mean	-97.1143871
Median Absolute Deviation (MAD)	15.437678
Skewness	-0.2388887569
Sum	-276323644.4
Variance	335.5356576
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-80.334179	755	< 0.1%
-80.416621	709	< 0.1%
-80.336612	589	< 0.1%
-81.477219	586	< 0.1%
-81.399777	583	< 0.1%
-80.293318	576	< 0.1%
-81.471375	565	< 0.1%
-80.416521	547	< 0.1%
-77.475128	525	< 0.1%
-78.680237	522	< 0.1%
Other values (1105394)	2839385	99.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-124.545748	2	< 0.1%
-124.509263	1	< 0.1%
-124.497829	1	< 0.1%
-124.497478	2	< 0.1%
-124.49747	1	< 0.1%
-124.497438	2	< 0.1%
-124.497421	1	< 0.1%
-124.497419	5	< 0.1%
-124.49741	1	< 0.1%
-124.497357	1	< 0.1%

Value	Count	Frequency (%)
-67.109242	1	< 0.1%
-67.40355	1	< 0.1%
-67.48413	1	< 0.1%
-67.606864	1	< 0.1%
-67.62034	1	< 0.1%
-67.626576	1	< 0.1%
-67.626605	1	< 0.1%
-67.706448	1	< 0.1%
-67.739817	1	< 0.1%
-67.78734	1	< 0.1%

Distance(mi)
Real number (ℝ_≥0)

ZEROS

Distinct	14165
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.7026778946

Minimum	0
Maximum	155.186
Zeros	385441
Zeros (%)	13.5%
Negative	0
Negative (%)	0.0%
Memory size	21.7 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.052
median	0.244
Q3	0.764
95-th percentile	2.894
Maximum	155.186
Range	155.186
Interquartile range (IQR)	0.712

Descriptive statistics

Standard deviation	1.560360825
Coefficient of variation (CV)	2.220591878
Kurtosis	806.7243696
Mean	0.7026778946
Median Absolute Deviation (MAD)	0.238
Skewness	16.67083479
Sum	1999358.926
Variance	2.434725905
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	385441	13.5%
0.008	9262	0.3%
0.009	8978	0.3%
0.01	8737	0.3%
0.007	7846	0.3%
0.011	7319	0.3%
0.03	6937	0.2%
0.012	6894	0.2%
0.028	6789	0.2%
0.024	6777	0.2%
Other values (14155)	2390362	84.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	385441	13.5%
0.001	4897	0.2%
0.002	2605	0.1%
0.003	3388	0.1%
0.004	4670	0.2%
0.005	5608	0.2%
0.006	6687	0.2%
0.007	7846	0.3%
0.008	9262	0.3%
0.009	8978	0.3%

Value	Count	Frequency (%)
155.186	1	< 0.1%
153.663	1	< 0.1%
152.543	1	< 0.1%
151.525	1	< 0.1%
150.138	1	< 0.1%
149.69	1	< 0.1%
149.687	1	< 0.1%
143.242	1	< 0.1%
138.562	1	< 0.1%
137.618	1	< 0.1%

Description
Categorical

HIGH CARDINALITY

Distinct	1174563
Distinct (%)	41.3%
Missing	0
Missing (%)	0.0%
Memory size	21.7 MiB

A crash has occurred causing no to minimum delays. Use caution.	7978
A crash has occurred use caution.	2531
An unconfirmed report of a crash has been received. Use caution.	2308
Hazardous debris is causing no to minimum delays. Use caution.	2095
At I-15 - Accident.	2070
Other values (1174558)	2828360

Length

Max length	577
Median length	375
Mean length	66.62176919
Min length	2

Characters and Unicode

Total characters	189561718
Distinct characters	98
Distinct categories	15 ?
Distinct scripts	2 ?
Distinct blocks	4 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	790550 ?
Unique (%)	27.8%

Sample

1st row	Between Sawmill Rd/Exit 20 and OH-315/Olentangy Riv Rd/Exit 22 - Accident.
2nd row	At OH-4/OH-235/Exit 41 - Accident.
3rd row	At I-71/US-50/Exit 1 - Accident.
4th row	At Dart Ave/Exit 21 - Accident.
5th row	At Mitchell Ave/Exit 6 - Accident.

Common Values

Value	Count	Frequency (%)
A crash has occurred causing no to minimum delays. Use caution.	7978	0.3%
A crash has occurred use caution.	2531	0.1%
An unconfirmed report of a crash has been received. Use caution.	2308	0.1%
Hazardous debris is causing no to minimum delays. Use caution.	2095	0.1%
At I-15 - Accident.	2070	0.1%
A disabled vehicle is creating a hazard causing no to minimum delays. Use caution.	1912	0.1%
At I-5 - Accident.	1907	0.1%
At I-405/San Diego Fwy - Accident.	1769	0.1%
At I-605 - Accident.	1486	0.1%
Incident on I-95 NB near I-95 Drive with caution.	1304	< 0.1%
Other values (1174553)	2819982	99.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
accident	1798430	5.3%
to	1650005	4.9%
on	1598467	4.8%
	1564037	4.7%
at	916875	2.7%
near	878801	2.6%
incident	856768	2.5%
from	796136	2.4%
due	782840	2.3%
rd	735640	2.2%
Other values (162605)	22044277	65.6%

Most occurring characters

Value	Count	Frequency (%)
	30776871	16.2%
t	11717120	6.2%
e	10644059	5.6%
n	9885855	5.2%
o	8424876	4.4%
i	8301886	4.4%
a	7363979	3.9%
c	7074776	3.7%
d	6570628	3.5%
r	5919544	3.1%
Other values (88)	82882124	43.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	98347096	51.9%
Uppercase Letter	34299454	18.1%
Space Separator	30777852	16.2%
Decimal Number	12986970	6.9%
Other Punctuation	5243233	2.8%
Dash Punctuation	5217447	2.8%
Open Punctuation	1344559	0.7%
Close Punctuation	1344492	0.7%
Math Symbol	365	< 0.1%
Modifier Symbol	102	< 0.1%
Other values (5)	148	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
t	11717120	11.9%
e	10644059	10.8%
n	9885855	10.1%
o	8424876	8.6%
i	8301886	8.4%
a	7363979	7.5%
c	7074776	7.2%
d	6570628	6.7%
r	5919544	6.0%
l	3533392	3.6%
Other values (19)	18910981	19.2%

Uppercase Letter

Value	Count	Frequency (%)
A	4238891	12.4%
S	3746799	10.9%
I	3061578	8.9%
E	2940823	8.6%
R	2604603	7.6%
D	1817116	5.3%
N	1709487	5.0%
C	1555252	4.5%
L	1501320	4.4%
B	1449485	4.2%
Other values (16)	9674100	28.2%

Other Punctuation

Value	Count	Frequency (%)
.	3211573	61.3%
/	1897673	36.2%
:	65712	1.3%
'	26434	0.5%
;	25138	0.5%
*	7522	0.1%
&	5856	0.1%
#	2864	0.1%
@	305	< 0.1%
?	92	< 0.1%
Other values (4)	64	< 0.1%

Decimal Number

Value	Count	Frequency (%)
1	2269949	17.5%
5	1571097	12.1%
2	1555128	12.0%
0	1459676	11.2%
4	1186461	9.1%
9	1130460	8.7%
3	1026620	7.9%
6	945893	7.3%
8	940013	7.2%
7	901673	6.9%

Open Punctuation

Value	Count	Frequency (%)
(	1239926	92.2%
[	101888	7.6%
{	2745	0.2%

Close Punctuation

Value	Count	Frequency (%)
)	1239866	92.2%
]	101881	7.6%
}	2745	0.2%

Math Symbol

Value	Count	Frequency (%)
+	161	44.1%
=	135	37.0%
~	69	18.9%

Space Separator

Value	Count	Frequency (%)
	30776871	> 99.9%
	981	< 0.1%

Modifier Symbol

Value	Count	Frequency (%)
^	100	98.0%
`	2	2.0%

Dash Punctuation

Value	Count	Frequency (%)
-	5217447	100.0%

Control

Value	Count	Frequency (%)
	96	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	42	100.0%

Currency Symbol

Value	Count	Frequency (%)
$	6	100.0%

Final Punctuation

Value	Count	Frequency (%)
’	2	100.0%

Other Symbol

Value	Count	Frequency (%)
�	2	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	132646550	70.0%
Common	56915168	30.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
t	11717120	8.8%
e	10644059	8.0%
n	9885855	7.5%
o	8424876	6.4%
i	8301886	6.3%
a	7363979	5.6%
c	7074776	5.3%
d	6570628	5.0%
r	5919544	4.5%
A	4238891	3.2%
Other values (45)	52504936	39.6%

Common

Value	Count	Frequency (%)
	30776871	54.1%
-	5217447	9.2%
.	3211573	5.6%
1	2269949	4.0%
/	1897673	3.3%
5	1571097	2.8%
2	1555128	2.7%
0	1459676	2.6%
(	1239926	2.2%
)	1239866	2.2%
Other values (33)	6475962	11.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	189560715	> 99.9%
None	997	< 0.1%
Punctuation	4	< 0.1%
Specials	2	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	30776871	16.2%
t	11717120	6.2%
e	10644059	5.6%
n	9885855	5.2%
o	8424876	4.4%
i	8301886	4.4%
a	7363979	3.9%
c	7074776	3.7%
d	6570628	3.5%
r	5919544	3.1%
Other values (81)	82881121	43.7%

None

Value	Count	Frequency (%)
	981	98.4%
ñ	8	0.8%
é	7	0.7%
í	1	0.1%

Punctuation

Value	Count	Frequency (%)
’	2	50.0%
•	2	50.0%

Specials

Value	Count	Frequency (%)
�	2	100.0%

Number
Real number (ℝ_≥0)

MISSING
SKEWED

Distinct	46402
Distinct (%)	4.2%
Missing	1743911
Missing (%)	61.3%
Infinite	0
Infinite (%)	0.0%
Mean	8089.408114

Minimum	0
Maximum	9999997
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	21.7 MiB

Quantile statistics

Minimum	0
5-th percentile	108
Q1	1270
median	4007
Q3	9567
95-th percentile	28661.5
Maximum	9999997
Range	9999997
Interquartile range (IQR)	8297

Descriptive statistics

Standard deviation	18360.09399
Coefficient of variation (CV)	2.269646152
Kurtosis	79967.464
Mean	8089.408114
Median Absolute Deviation (MAD)	3309
Skewness	156.9450181
Sum	8909924868
Variance	337093051.5
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	10662	0.4%
2	8747	0.3%
101	6706	0.2%
100	6187	0.2%
198	2617	0.1%
298	2270	0.1%
200	2228	0.1%
201	2224	0.1%
398	2191	0.1%
199	2116	0.1%
Other values (46392)	1055483	37.1%
(Missing)	1743911	61.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	10662	0.4%
2	8747	0.3%
3	622	< 0.1%
4	557	< 0.1%
5	336	< 0.1%
6	306	< 0.1%
7	256	< 0.1%
8	301	< 0.1%
9	269	< 0.1%

Value	Count	Frequency (%)
9999997	1	< 0.1%
961061	1	< 0.1%
961052	1	< 0.1%
961051	2	< 0.1%
961043	1	< 0.1%
961005	1	< 0.1%
942501	1	< 0.1%
941996	1	< 0.1%
940884	1	< 0.1%
852564	1	< 0.1%

Street
Categorical

HIGH CARDINALITY

Distinct	159651
Distinct (%)	5.6%
Missing	2
Missing (%)	< 0.1%
Memory size	21.7 MiB

I-95 N	39853
I-5 N	39402
I-95 S	36425
I-5 S	30229
I-10 E	26164
Other values (159646)	2673267

Length

Max length	51
Median length	46
Mean length	11.16221682
Min length	2

Characters and Unicode

Total characters	31760302
Distinct characters	72
Distinct categories	7 ?
Distinct scripts	2 ?
Distinct blocks	3 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	64154 ?
Unique (%)	2.3%

Sample

1st row	Outerbelt E
2nd row	I-70 E
3rd row	I-75 S
4th row	I-77 N
5th row	I-75 S

Common Values

Value	Count	Frequency (%)
I-95 N	39853	1.4%
I-5 N	39402	1.4%
I-95 S	36425	1.3%
I-5 S	30229	1.1%
I-10 E	26164	0.9%
I-10 W	25298	0.9%
I-80 W	17545	0.6%
I-80 E	16873	0.6%
I-405 N	13708	0.5%
I-15 N	12675	0.4%
Other values (159641)	2587168	90.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
n	514849	7.1%
s	512084	7.1%
w	394072	5.5%
e	392955	5.5%
rd	344344	4.8%
ave	228318	3.2%
st	215172	3.0%
fwy	149795	2.1%
highway	149101	2.1%
blvd	112666	1.6%
Other values (43749)	4195437	58.2%

Most occurring characters

Value	Count	Frequency (%)
	5464883	17.2%
e	1620891	5.1%
a	1390354	4.4%
S	1151559	3.6%
t	1124812	3.5%
-	1076858	3.4%
r	1050604	3.3%
o	1041312	3.3%
n	1002552	3.2%
l	939981	3.0%
Other values (62)	15896496	50.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	14683462	46.2%
Uppercase Letter	7354331	23.2%
Space Separator	5464883	17.2%
Decimal Number	3163551	10.0%
Dash Punctuation	1076858	3.4%
Other Punctuation	16875	0.1%
Other Symbol	342	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	1620891	11.0%
a	1390354	9.5%
t	1124812	7.7%
r	1050604	7.2%
o	1041312	7.1%
n	1002552	6.8%
l	939981	6.4%
i	913631	6.2%
d	897396	6.1%
y	797274	5.4%
Other values (18)	3904655	26.6%

Uppercase Letter

Value	Count	Frequency (%)
S	1151559	15.7%
I	819857	11.1%
N	655079	8.9%
W	606436	8.2%
E	556151	7.6%
A	488039	6.6%
R	479994	6.5%
C	373251	5.1%
H	361322	4.9%
B	313233	4.3%
Other values (16)	1549410	21.1%

Decimal Number

Value	Count	Frequency (%)
5	493665	15.6%
0	451804	14.3%
1	442418	14.0%
9	319319	10.1%
4	295166	9.3%
2	266844	8.4%
8	262531	8.3%
7	229622	7.3%
6	227316	7.2%
3	174866	5.5%

Other Punctuation

Value	Count	Frequency (%)
'	11457	67.9%
.	4230	25.1%
/	1186	7.0%
&	1	< 0.1%
;	1	< 0.1%

Space Separator

Value	Count	Frequency (%)
	5464883	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	1076858	100.0%

Other Symbol

Value	Count	Frequency (%)
�	342	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	22037793	69.4%
Common	9722509	30.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	1620891	7.4%
a	1390354	6.3%
S	1151559	5.2%
t	1124812	5.1%
r	1050604	4.8%
o	1041312	4.7%
n	1002552	4.5%
l	939981	4.3%
i	913631	4.1%
d	897396	4.1%
Other values (44)	10904701	49.5%

Common

Value	Count	Frequency (%)
	5464883	56.2%
-	1076858	11.1%
5	493665	5.1%
0	451804	4.6%
1	442418	4.6%
9	319319	3.3%
4	295166	3.0%
2	266844	2.7%
8	262531	2.7%
7	229622	2.4%
Other values (8)	419399	4.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	31759462	> 99.9%
None	498	< 0.1%
Specials	342	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	5464883	17.2%
e	1620891	5.1%
a	1390354	4.4%
S	1151559	3.6%
t	1124812	3.5%
-	1076858	3.4%
r	1050604	3.3%
o	1041312	3.3%
n	1002552	3.2%
l	939981	3.0%
Other values (59)	15895656	50.1%

None

Value	Count	Frequency (%)
é	489	98.2%
ñ	9	1.8%

Specials

Value	Count	Frequency (%)
�	342	100.0%

Side
Categorical

HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	21.7 MiB

R	2353309
L	492032
N	1

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	2845342
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	R
2nd row	R
3rd row	R
4th row	R
5th row	R

Common Values

Value	Count	Frequency (%)
R	2353309	82.7%
L	492032	17.3%
N	1	< 0.1%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
r	2353309	82.7%
l	492032	17.3%
n	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
R	2353309	82.7%
L	492032	17.3%
N	1	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	2845342	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
R	2353309	82.7%
L	492032	17.3%
N	1	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2845342	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
R	2353309	82.7%
L	492032	17.3%
N	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2845342	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
R	2353309	82.7%
L	492032	17.3%
N	1	< 0.1%

City
Categorical

HIGH CARDINALITY

Distinct	11681
Distinct (%)	0.4%
Missing	137
Missing (%)	< 0.1%
Memory size	21.7 MiB

Miami	106966
Los Angeles	68956
Orlando	54691
Dallas	41979
Houston	39448
Other values (11676)	2533165

Length

Max length	30
Median length	26
Mean length	8.810501177
Min length	3

Characters and Unicode

Total characters	25067682
Distinct characters	65
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1110 ?
Unique (%)	< 0.1%

Sample

1st row	Dublin
2nd row	Dayton
3rd row	Cincinnati
4th row	Akron
5th row	Cincinnati

Common Values

Value	Count	Frequency (%)
Miami	106966	3.8%
Los Angeles	68956	2.4%
Orlando	54691	1.9%
Dallas	41979	1.5%
Houston	39448	1.4%
Charlotte	33152	1.2%
Sacramento	32559	1.1%
San Diego	26627	0.9%
Raleigh	22840	0.8%
Minneapolis	22768	0.8%
Other values (11671)	2395219	84.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
miami	119442	3.2%
san	87961	2.4%
los	74220	2.0%
city	69201	1.9%
angeles	69027	1.9%
orlando	54691	1.5%
dallas	42171	1.1%
saint	40075	1.1%
houston	39455	1.1%
beach	39263	1.1%
Other values (9456)	3086433	82.9%

Most occurring characters

Value	Count	Frequency (%)
a	2502556	10.0%
e	2221044	8.9%
n	1890139	7.5%
o	1878078	7.5%
l	1661139	6.6%
i	1634406	6.5%
r	1492423	6.0%
t	1316077	5.3%
s	1161930	4.6%
	876734	3.5%
Other values (55)	8433156	33.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	20468277	81.7%
Uppercase Letter	3721941	14.8%
Space Separator	876734	3.5%
Dash Punctuation	320	< 0.1%
Decimal Number	255	< 0.1%
Other Punctuation	155	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	2502556	12.2%
e	2221044	10.9%
n	1890139	9.2%
o	1878078	9.2%
l	1661139	8.1%
i	1634406	8.0%
r	1492423	7.3%
t	1316077	6.4%
s	1161930	5.7%
d	645556	3.2%
Other values (16)	4064929	19.9%

Uppercase Letter

Value	Count	Frequency (%)
S	392746	10.6%
C	362436	9.7%
M	333442	9.0%
L	266542	7.2%
B	259083	7.0%
P	242493	6.5%
A	220680	5.9%
H	200735	5.4%
R	187703	5.0%
O	160396	4.3%
Other values (16)	1095685	29.4%

Decimal Number

Value	Count	Frequency (%)
4	162	63.5%
5	40	15.7%
7	19	7.5%
1	16	6.3%
6	5	2.0%
8	3	1.2%
2	3	1.2%
3	3	1.2%
0	2	0.8%
9	2	0.8%

Space Separator

Value	Count	Frequency (%)
	876734	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	320	100.0%

Other Punctuation

Value	Count	Frequency (%)
.	155	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	24190218	96.5%
Common	877464	3.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	2502556	10.3%
e	2221044	9.2%
n	1890139	7.8%
o	1878078	7.8%
l	1661139	6.9%
i	1634406	6.8%
r	1492423	6.2%
t	1316077	5.4%
s	1161930	4.8%
d	645556	2.7%
Other values (42)	7786870	32.2%

Common

Value	Count	Frequency (%)
	876734	99.9%
-	320	< 0.1%
4	162	< 0.1%
.	155	< 0.1%
5	40	< 0.1%
7	19	< 0.1%
1	16	< 0.1%
6	5	< 0.1%
8	3	< 0.1%
2	3	< 0.1%
Other values (3)	7	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	25067682	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	2502556	10.0%
e	2221044	8.9%
n	1890139	7.5%
o	1878078	7.5%
l	1661139	6.6%
i	1634406	6.5%
r	1492423	6.0%
t	1316077	5.3%
s	1161930	4.6%
	876734	3.5%
Other values (55)	8433156	33.6%

County
Categorical

HIGH CARDINALITY

Distinct	1707
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	21.7 MiB

Los Angeles	234122
Miami-Dade	143939
Orange	114917
San Bernardino	55018
Dallas	50050
Other values (1702)	2247296

Length

Max length	20
Median length	16
Mean length	8.195874521
Min length	3

Characters and Unicode

Total characters	23320066
Distinct characters	57
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	3 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	66 ?
Unique (%)	< 0.1%

Sample

1st row	Franklin
2nd row	Montgomery
3rd row	Hamilton
4th row	Summit
5th row	Hamilton

Common Values

Value	Count	Frequency (%)
Los Angeles	234122	8.2%
Miami-Dade	143939	5.1%
Orange	114917	4.0%
San Bernardino	55018	1.9%
Dallas	50050	1.8%
San Diego	48366	1.7%
Sacramento	46708	1.6%
Harris	42559	1.5%
Riverside	42176	1.5%
Montgomery	41476	1.5%
Other values (1697)	2026011	71.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
los	234123	6.6%
angeles	234122	6.6%
san	145652	4.1%
miami-dade	143939	4.1%
orange	114917	3.3%
bernardino	55018	1.6%
dallas	50050	1.4%
diego	48366	1.4%
sacramento	46708	1.3%
santa	43738	1.2%
Other values (1668)	2418952	68.4%

Most occurring characters

Value	Count	Frequency (%)
a	2602218	11.2%
e	2445101	10.5%
n	1899466	8.1%
o	1619413	6.9%
r	1442849	6.2%
i	1307901	5.6%
s	1284451	5.5%
l	1157072	5.0%
t	785883	3.4%
	690243	3.0%
Other values (47)	8085469	34.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	18767444	80.5%
Uppercase Letter	3684912	15.8%
Space Separator	690243	3.0%
Dash Punctuation	144233	0.6%
Other Punctuation	33203	0.1%
Other Symbol	31	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	2602218	13.9%
e	2445101	13.0%
n	1899466	10.1%
o	1619413	8.6%
r	1442849	7.7%
i	1307901	7.0%
s	1284451	6.8%
l	1157072	6.2%
t	785883	4.2%
g	678325	3.6%
Other values (17)	3544765	18.9%

Uppercase Letter

Value	Count	Frequency (%)
M	414228	11.2%
S	394862	10.7%
L	372320	10.1%
D	369042	10.0%
A	336667	9.1%
C	287055	7.8%
B	212764	5.8%
H	173937	4.7%
O	173249	4.7%
P	139348	3.8%
Other values (15)	811440	22.0%

Other Punctuation

Value	Count	Frequency (%)
.	18431	55.5%
'	14772	44.5%

Space Separator

Value	Count	Frequency (%)
	690243	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	144233	100.0%

Other Symbol

Value	Count	Frequency (%)
�	31	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	22452356	96.3%
Common	867710	3.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	2602218	11.6%
e	2445101	10.9%
n	1899466	8.5%
o	1619413	7.2%
r	1442849	6.4%
i	1307901	5.8%
s	1284451	5.7%
l	1157072	5.2%
t	785883	3.5%
g	678325	3.0%
Other values (42)	7229677	32.2%

Common

Value	Count	Frequency (%)
	690243	79.5%
-	144233	16.6%
.	18431	2.1%
'	14772	1.7%
�	31	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	23319942	> 99.9%
None	93	< 0.1%
Specials	31	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	2602218	11.2%
e	2445101	10.5%
n	1899466	8.1%
o	1619413	6.9%
r	1442849	6.2%
i	1307901	5.6%
s	1284451	5.5%
l	1157072	5.0%
t	785883	3.4%
	690243	3.0%
Other values (45)	8085345	34.7%

None

Value	Count	Frequency (%)
ñ	93	100.0%

Specials

Value	Count	Frequency (%)
�	31	100.0%

State
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	49
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	21.7 MiB

CA	795868
FL	401388
TX	149037
OR	126341
VA	113535
Other values (44)	1259173

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	5690684
Distinct characters	24
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	OH
2nd row	OH
3rd row	OH
4th row	OH
5th row	OH

Common Values

Value	Count	Frequency (%)
CA	795868	28.0%
FL	401388	14.1%
TX	149037	5.2%
OR	126341	4.4%
VA	113535	4.0%
NY	108049	3.8%
PA	99975	3.5%
MN	97185	3.4%
NC	91362	3.2%
SC	89216	3.1%
Other values (39)	773386	27.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
ca	795868	28.0%
fl	401388	14.1%
tx	149037	5.2%
or	126341	4.4%
va	113535	4.0%
ny	108049	3.8%
pa	99975	3.5%
mn	97185	3.4%
nc	91362	3.2%
sc	89216	3.1%
Other values (39)	773386	27.2%

Most occurring characters

Value	Count	Frequency (%)
A	1232010	21.6%
C	1040681	18.3%
L	515047	9.1%
N	440972	7.7%
F	401388	7.1%
T	296934	5.2%
M	267985	4.7%
O	214529	3.8%
X	149037	2.6%
I	142296	2.5%
Other values (14)	989805	17.4%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	5690684	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	1232010	21.6%
C	1040681	18.3%
L	515047	9.1%
N	440972	7.7%
F	401388	7.1%
T	296934	5.2%
M	267985	4.7%
O	214529	3.8%
X	149037	2.6%
I	142296	2.5%
Other values (14)	989805	17.4%

Most occurring scripts

Value	Count	Frequency (%)
Latin	5690684	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	1232010	21.6%
C	1040681	18.3%
L	515047	9.1%
N	440972	7.7%
F	401388	7.1%
T	296934	5.2%
M	267985	4.7%
O	214529	3.8%
X	149037	2.6%
I	142296	2.5%
Other values (14)	989805	17.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5690684	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	1232010	21.6%
C	1040681	18.3%
L	515047	9.1%
N	440972	7.7%
F	401388	7.1%
T	296934	5.2%
M	267985	4.7%
O	214529	3.8%
X	149037	2.6%
I	142296	2.5%
Other values (14)	989805	17.4%

Zipcode
Categorical

HIGH CARDINALITY

Distinct	363085
Distinct (%)	12.8%
Missing	1319
Missing (%)	< 0.1%
Memory size	21.7 MiB

91761	6162
33186	5248
92407	4528
92507	4527
91706	4471
Other values (363080)	2819087

Length

Max length	10
Median length	5
Mean length	6.409737193
Min length	5

Characters and Unicode

Total characters	18229440
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	209614 ?
Unique (%)	7.4%

Sample

1st row	43017
2nd row	45424
3rd row	45203
4th row	44311
5th row	45217

Common Values

Value	Count	Frequency (%)
91761	6162	0.2%
33186	5248	0.2%
92407	4528	0.2%
92507	4527	0.2%
91706	4471	0.2%
33183	3518	0.1%
92324	3491	0.1%
32819	3455	0.1%
33169	3439	0.1%
91765	3189	0.1%
Other values (363075)	2801995	98.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
91761	6162	0.2%
33186	5248	0.2%
92407	4528	0.2%
92507	4527	0.2%
91706	4471	0.2%
33183	3518	0.1%
92324	3491	0.1%
32819	3455	0.1%
33169	3439	0.1%
91765	3189	0.1%
Other values (363075)	2801995	98.5%

Most occurring characters

Value	Count	Frequency (%)
0	2252352	12.4%
2	2174309	11.9%
3	2173091	11.9%
1	2043786	11.2%
9	1788058	9.8%
5	1575164	8.6%
7	1519116	8.3%
4	1485471	8.1%
6	1243905	6.8%
8	1172323	6.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	17427575	95.6%
Dash Punctuation	801865	4.4%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	2252352	12.9%
2	2174309	12.5%
3	2173091	12.5%
1	2043786	11.7%
9	1788058	10.3%
5	1575164	9.0%
7	1519116	8.7%
4	1485471	8.5%
6	1243905	7.1%
8	1172323	6.7%

Dash Punctuation

Value	Count	Frequency (%)
-	801865	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	18229440	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	2252352	12.4%
2	2174309	11.9%
3	2173091	11.9%
1	2043786	11.2%
9	1788058	9.8%
5	1575164	8.6%
7	1519116	8.3%
4	1485471	8.1%
6	1243905	6.8%
8	1172323	6.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	18229440	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	2252352	12.4%
2	2174309	11.9%
3	2173091	11.9%
1	2043786	11.2%
9	1788058	9.8%
5	1575164	8.6%
7	1519116	8.3%
4	1485471	8.1%
6	1243905	6.8%
8	1172323	6.4%

Country
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	21.7 MiB

US	2845342

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	5690684
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	US
2nd row	US
3rd row	US
4th row	US
5th row	US

Common Values

Value	Count	Frequency (%)
US	2845342	100.0%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
us	2845342	100.0%

Most occurring characters

Value	Count	Frequency (%)
U	2845342	50.0%
S	2845342	50.0%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	5690684	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
U	2845342	50.0%
S	2845342	50.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	5690684	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
U	2845342	50.0%
S	2845342	50.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5690684	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
U	2845342	50.0%
S	2845342	50.0%

Timezone
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	4
Distinct (%)	< 0.1%
Missing	3659
Missing (%)	0.1%
Memory size	21.7 MiB

US/Eastern	1221927
US/Pacific	967094
US/Central	488065
US/Mountain	164597

Length

Max length	11
Median length	10
Mean length	10.05792237
Min length	10

Characters and Unicode

Total characters	28581427
Distinct characters	19
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	US/Eastern
2nd row	US/Eastern
3rd row	US/Eastern
4th row	US/Eastern
5th row	US/Eastern

Common Values

Value	Count	Frequency (%)
US/Eastern	1221927	42.9%
US/Pacific	967094	34.0%
US/Central	488065	17.2%
US/Mountain	164597	5.8%
(Missing)	3659	0.1%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
us/eastern	1221927	43.0%
us/pacific	967094	34.0%
us/central	488065	17.2%
us/mountain	164597	5.8%

Most occurring characters

Value	Count	Frequency (%)
U	2841683	9.9%
S	2841683	9.9%
/	2841683	9.9%
a	2841683	9.9%
i	2098785	7.3%
n	2039186	7.1%
c	1934188	6.8%
t	1874589	6.6%
e	1709992	6.0%
r	1709992	6.0%
Other values (9)	5847963	20.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	17214695	60.2%
Uppercase Letter	8525049	29.8%
Other Punctuation	2841683	9.9%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	2841683	16.5%
i	2098785	12.2%
n	2039186	11.8%
c	1934188	11.2%
t	1874589	10.9%
e	1709992	9.9%
r	1709992	9.9%
s	1221927	7.1%
f	967094	5.6%
l	488065	2.8%
Other values (2)	329194	1.9%

Uppercase Letter

Value	Count	Frequency (%)
U	2841683	33.3%
S	2841683	33.3%
E	1221927	14.3%
P	967094	11.3%
C	488065	5.7%
M	164597	1.9%

Other Punctuation

Value	Count	Frequency (%)
/	2841683	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	25739744	90.1%
Common	2841683	9.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
U	2841683	11.0%
S	2841683	11.0%
a	2841683	11.0%
i	2098785	8.2%
n	2039186	7.9%
c	1934188	7.5%
t	1874589	7.3%
e	1709992	6.6%
r	1709992	6.6%
s	1221927	4.7%
Other values (8)	4626036	18.0%

Common

Value	Count	Frequency (%)
/	2841683	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	28581427	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
U	2841683	9.9%
S	2841683	9.9%
/	2841683	9.9%
a	2841683	9.9%
i	2098785	7.3%
n	2039186	7.1%
c	1934188	6.8%
t	1874589	6.6%
e	1709992	6.0%
r	1709992	6.0%
Other values (9)	5847963	20.5%

Airport_Code
Categorical

HIGH CARDINALITY

Distinct	2004
Distinct (%)	0.1%
Missing	9549
Missing (%)	0.3%
Memory size	21.7 MiB

KCQT	52790
KMIA	45740
KORL	39380
KOPF	38556
KTMB	36250
Other values (1999)	2623077

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	11343172
Distinct characters	36
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	48 ?
Unique (%)	< 0.1%

Sample

1st row	KOSU
2nd row	KFFO
3rd row	KLUK
4th row	KAKR
5th row	KLUK

Common Values

Value	Count	Frequency (%)
KCQT	52790	1.9%
KMIA	45740	1.6%
KORL	39380	1.4%
KOPF	38556	1.4%
KTMB	36250	1.3%
KEMT	29931	1.1%
KRDU	29322	1.0%
KFUL	28575	1.0%
KHHR	27305	1.0%
KBNA	27061	1.0%
Other values (1994)	2480883	87.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
kcqt	52790	1.9%
kmia	45740	1.6%
korl	39380	1.4%
kopf	38556	1.4%
ktmb	36250	1.3%
kemt	29931	1.1%
krdu	29322	1.0%
kful	28575	1.0%
khhr	27305	1.0%
kbna	27061	1.0%
Other values (1994)	2480883	87.5%

Most occurring characters

Value	Count	Frequency (%)
K	2996056	26.4%
A	594595	5.2%
C	587310	5.2%
M	541139	4.8%
S	498222	4.4%
T	476820	4.2%
L	467659	4.1%
O	449386	4.0%
R	439134	3.9%
D	437371	3.9%
Other values (26)	3855480	34.0%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	11189338	98.6%
Decimal Number	153834	1.4%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
K	2996056	26.8%
A	594595	5.3%
C	587310	5.2%
M	541139	4.8%
S	498222	4.5%
T	476820	4.3%
L	467659	4.2%
O	449386	4.0%
R	439134	3.9%
D	437371	3.9%
Other values (16)	3701646	33.1%

Decimal Number

Value	Count	Frequency (%)
2	33233	21.6%
6	25327	16.5%
4	23061	15.0%
3	16538	10.8%
7	13339	8.7%
0	12452	8.1%
9	10951	7.1%
1	10758	7.0%
8	4389	2.9%
5	3786	2.5%

Most occurring scripts

Value	Count	Frequency (%)
Latin	11189338	98.6%
Common	153834	1.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
K	2996056	26.8%
A	594595	5.3%
C	587310	5.2%
M	541139	4.8%
S	498222	4.5%
T	476820	4.3%
L	467659	4.2%
O	449386	4.0%
R	439134	3.9%
D	437371	3.9%
Other values (16)	3701646	33.1%

Common

Value	Count	Frequency (%)
2	33233	21.6%
6	25327	16.5%
4	23061	15.0%
3	16538	10.8%
7	13339	8.7%
0	12452	8.1%
9	10951	7.1%
1	10758	7.0%
8	4389	2.9%
5	3786	2.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	11343172	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
K	2996056	26.4%
A	594595	5.2%
C	587310	5.2%
M	541139	4.8%
S	498222	4.4%
T	476820	4.2%
L	467659	4.1%
O	449386	4.0%
R	439134	3.9%
D	437371	3.9%
Other values (26)	3855480	34.0%

Weather_Timestamp
Categorical

HIGH CARDINALITY
MISSING

Distinct	474214
Distinct (%)	17.0%
Missing	50736
Missing (%)	1.8%
Memory size	21.7 MiB

2021-12-17 14:53:00	640
2021-12-23 14:53:00	629
2021-01-26 15:53:00	598
2021-12-06 16:53:00	595
2021-12-03 16:53:00	593
Other values (474209)	2791551

Length

Max length	19
Median length	19
Mean length	19
Min length	19

Characters and Unicode

Total characters	53097514
Distinct characters	13
Distinct categories	4 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	186552 ?
Unique (%)	6.7%

Sample

1st row	2016-02-08 00:53:00
2nd row	2016-02-08 05:58:00
3rd row	2016-02-08 05:53:00
4th row	2016-02-08 06:54:00
5th row	2016-02-08 07:53:00

Common Values

Value	Count	Frequency (%)
2021-12-17 14:53:00	640	< 0.1%
2021-12-23 14:53:00	629	< 0.1%
2021-01-26 15:53:00	598	< 0.1%
2021-12-06 16:53:00	595	< 0.1%
2021-12-03 16:53:00	593	< 0.1%
2021-12-17 17:53:00	572	< 0.1%
2021-11-30 16:53:00	569	< 0.1%
2021-12-15 16:53:00	567	< 0.1%
2021-12-03 14:53:00	565	< 0.1%
2021-12-07 16:53:00	560	< 0.1%
Other values (474204)	2788718	98.0%
(Missing)	50736	1.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
16:53:00	95753	1.7%
15:53:00	94214	1.7%
14:53:00	88219	1.6%
17:53:00	85653	1.5%
13:53:00	75857	1.4%
12:53:00	66186	1.2%
18:53:00	59874	1.1%
07:53:00	55202	1.0%
11:53:00	50706	0.9%
08:53:00	46872	0.8%
Other values (3529)	4870676	87.1%

Most occurring characters

Value	Count	Frequency (%)
0	13312181	25.1%
2	7541273	14.2%
1	7373996	13.9%
-	5589212	10.5%
:	5589212	10.5%
5	3411025	6.4%
	2794606	5.3%
3	2200904	4.1%
6	1217216	2.3%
4	1064424	2.0%
Other values (3)	3003465	5.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	39124484	73.7%
Dash Punctuation	5589212	10.5%
Other Punctuation	5589212	10.5%
Space Separator	2794606	5.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	13312181	34.0%
2	7541273	19.3%
1	7373996	18.8%
5	3411025	8.7%
3	2200904	5.6%
6	1217216	3.1%
4	1064424	2.7%
7	1029347	2.6%
9	1012235	2.6%
8	961883	2.5%

Dash Punctuation

Value	Count	Frequency (%)
-	5589212	100.0%

Other Punctuation

Value	Count	Frequency (%)
:	5589212	100.0%

Space Separator

Value	Count	Frequency (%)
	2794606	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	53097514	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	13312181	25.1%
2	7541273	14.2%
1	7373996	13.9%
-	5589212	10.5%
:	5589212	10.5%
5	3411025	6.4%
	2794606	5.3%
3	2200904	4.1%
6	1217216	2.3%
4	1064424	2.0%
Other values (3)	3003465	5.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	53097514	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	13312181	25.1%
2	7541273	14.2%
1	7373996	13.9%
-	5589212	10.5%
:	5589212	10.5%
5	3411025	6.4%
	2794606	5.3%
3	2200904	4.1%
6	1217216	2.3%
4	1064424	2.0%
Other values (3)	3003465	5.7%

Temperature(F)
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	788
Distinct (%)	< 0.1%
Missing	69274
Missing (%)	2.4%
Infinite	0
Infinite (%)	0.0%
Mean	61.79355592

Minimum	-89
Maximum	196
Zeros	984
Zeros (%)	< 0.1%
Negative	6444
Negative (%)	0.2%
Memory size	21.7 MiB

Quantile statistics

Minimum	-89
5-th percentile	29
Q1	50
median	64
Q3	76
95-th percentile	88.9
Maximum	196
Range	285
Interquartile range (IQR)	26

Descriptive statistics

Standard deviation	18.62262938
Coefficient of variation (CV)	0.3013684697
Kurtosis	0.03002155249
Mean	61.79355592
Median Absolute Deviation (MAD)	13
Skewness	-0.4910794711
Sum	171543113.2
Variance	346.8023252
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
73	64505	2.3%
77	63575	2.2%
75	60534	2.1%
72	59681	2.1%
68	58557	2.1%
63	58259	2.0%
64	57937	2.0%
70	57760	2.0%
66	56336	2.0%
59	56025	2.0%
Other values (778)	2182899	76.7%
(Missing)	69274	2.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-89	2	< 0.1%
-77.8	1	< 0.1%
-58	1	< 0.1%
-50	1	< 0.1%
-40	1	< 0.1%
-33	1	< 0.1%
-30	1	< 0.1%
-29	4	< 0.1%
-28	2	< 0.1%
-27.9	2	< 0.1%

Value	Count	Frequency (%)
196	3	< 0.1%
170.6	1	< 0.1%
168.8	1	< 0.1%
156	1	< 0.1%
144	1	< 0.1%
136	1	< 0.1%
129.2	1	< 0.1%
127.4	1	< 0.1%
120	8	< 0.1%
119	5	< 0.1%

Wind_Chill(F)
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	897
Distinct (%)	< 0.1%
Missing	469643
Missing (%)	16.5%
Infinite	0
Infinite (%)	0.0%
Mean	59.6582309

Minimum	-89
Maximum	196
Zeros	1322
Zeros (%)	< 0.1%
Negative	20659
Negative (%)	0.7%
Memory size	21.7 MiB

Quantile statistics

Minimum	-89
5-th percentile	21
Q1	46
median	63
Q3	76
95-th percentile	88
Maximum	196
Range	285
Interquartile range (IQR)	30

Descriptive statistics

Standard deviation	21.16096744
Coefficient of variation (CV)	0.354703234
Kurtosis	0.3682111381
Mean	59.6582309
Median Absolute Deviation (MAD)	14
Skewness	-0.7082722667
Sum	141729999.5
Variance	447.7865429
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
73	56492	2.0%
77	53359	1.9%
75	52898	1.9%
72	52196	1.8%
63	50784	1.8%
64	50374	1.8%
70	50187	1.8%
79	48936	1.7%
66	48929	1.7%
68	48517	1.7%
Other values (887)	1863027	65.5%
(Missing)	469643	16.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-89	2	< 0.1%
-80	1	< 0.1%
-65.9	1	< 0.1%
-59	1	< 0.1%
-58	1	< 0.1%
-53.5	4	< 0.1%
-53.1	1	< 0.1%
-52.3	1	< 0.1%
-51.7	1	< 0.1%
-51.5	2	< 0.1%

Value	Count	Frequency (%)
196	3	< 0.1%
156	1	< 0.1%
144	1	< 0.1%
136	1	< 0.1%
120	8	< 0.1%
119	5	< 0.1%
117	11	< 0.1%
116	8	< 0.1%
115	13	< 0.1%
114	36	< 0.1%

Humidity(%)
Real number (ℝ_≥0)

MISSING

Distinct	100
Distinct (%)	< 0.1%
Missing	73092
Missing (%)	2.6%
Infinite	0
Infinite (%)	0.0%
Mean	64.36545225

Minimum	1
Maximum	100
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	21.7 MiB

Quantile statistics

Minimum	1
5-th percentile	23
Q1	48
median	67
Q3	83
95-th percentile	96
Maximum	100
Range	99
Interquartile range (IQR)	35

Descriptive statistics

Standard deviation	22.8745681
Coefficient of variation (CV)	0.3553858056
Kurtosis	-0.6827235834
Mean	64.36545225
Median Absolute Deviation (MAD)	17
Skewness	-0.4157629378
Sum	178437125
Variance	523.2458658
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
93	103607	3.6%
100	96907	3.4%
87	60236	2.1%
90	57587	2.0%
89	53396	1.9%
86	47702	1.7%
82	46793	1.6%
81	45330	1.6%
67	45180	1.6%
96	45111	1.6%
Other values (90)	2170401	76.3%
(Missing)	73092	2.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	26	< 0.1%
2	121	< 0.1%
3	341	< 0.1%
4	943	< 0.1%
5	1804	0.1%
6	2408	0.1%
7	3457	0.1%
8	4182	0.1%
9	4758	0.2%
10	5601	0.2%

Value	Count	Frequency (%)
100	96907	3.4%
99	4306	0.2%
98	2329	0.1%
97	29111	1.0%
96	45111	1.6%
95	3342	0.1%
94	39650	1.4%
93	103607	3.6%
92	23444	0.8%
91	12828	0.5%

Pressure(in)
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	1068
Distinct (%)	< 0.1%
Missing	59200
Missing (%)	2.1%
Infinite	0
Infinite (%)	0.0%
Mean	29.47234438

Minimum	0
Maximum	58.9
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	21.7 MiB

Quantile statistics

Minimum	0
5-th percentile	27.25
Q1	29.31
median	29.82
Q3	30.01
95-th percentile	30.21
Maximum	58.9
Range	58.9
Interquartile range (IQR)	0.7

Descriptive statistics

Standard deviation	1.045286497
Coefficient of variation (CV)	0.03546668983
Kurtosis	16.72394531
Mean	29.47234438
Median Absolute Deviation (MAD)	0.26
Skewness	-3.257540169
Sum	82114136.52
Variance	1.092623861
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
29.96	43668	1.5%
29.94	43165	1.5%
29.99	42978	1.5%
30.01	41736	1.5%
30.03	41477	1.5%
30.04	40651	1.4%
29.97	40395	1.4%
30	40178	1.4%
29.95	40084	1.4%
29.93	39474	1.4%
Other values (1058)	2372336	83.4%
(Missing)	59200	2.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	< 0.1%
0.02	1	< 0.1%
0.3	2	< 0.1%
2.99	2	< 0.1%
3.04	2	< 0.1%
16.72	2	< 0.1%
19.21	2	< 0.1%
19.24	2	< 0.1%
19.37	1	< 0.1%
19.48	1	< 0.1%

Value	Count	Frequency (%)
58.9	1	< 0.1%
58.16	2	< 0.1%
58.13	1	< 0.1%
58.04	2	< 0.1%
57.74	1	< 0.1%
56.54	1	< 0.1%
56.31	1	< 0.1%
52.76	2	< 0.1%
38.94	3	< 0.1%
32.87	1	< 0.1%

Visibility(mi)
Real number (ℝ_≥0)

MISSING

Distinct	76
Distinct (%)	< 0.1%
Missing	70546
Missing (%)	2.5%
Infinite	0
Infinite (%)	0.0%
Mean	9.09939131

Minimum	0
Maximum	140
Zeros	3238
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	21.7 MiB

Quantile statistics

Minimum	0
5-th percentile	3
Q1	10
median	10
Q3	10
95-th percentile	10
Maximum	140
Range	140
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	2.717545745
Coefficient of variation (CV)	0.298651377
Kurtosis	103.5064331
Mean	9.09939131
Median Absolute Deviation (MAD)	0
Skewness	3.113374137
Sum	25248954.61
Variance	7.385054877
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10	2230276	78.4%
7	79649	2.8%
9	68817	2.4%
8	55955	2.0%
5	53933	1.9%
6	49051	1.7%
2	46160	1.6%
4	45437	1.6%
3	44012	1.5%
1	38445	1.4%
Other values (66)	63061	2.2%
(Missing)	70546	2.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	3238	0.1%
0.06	118	< 0.1%
0.1	268	< 0.1%
0.12	726	< 0.1%
0.19	12	< 0.1%
0.2	2870	0.1%
0.25	11359	0.4%
0.38	130	< 0.1%
0.4	25	< 0.1%
0.5	12290	0.4%

Value	Count	Frequency (%)
140	2	< 0.1%
130	1	< 0.1%
120	4	< 0.1%
111	1	< 0.1%
110	1	< 0.1%
100	37	< 0.1%
90	9	< 0.1%
80	186	< 0.1%
75	33	< 0.1%
70	99	< 0.1%

Wind_Direction
Categorical

HIGH CORRELATION
MISSING

Distinct	24
Distinct (%)	< 0.1%
Missing	73775
Missing (%)	2.6%
Memory size	21.7 MiB

CALM	433622
S	169743
W	167830
WNW	145046
NW	141344
Other values (19)	1713982

Length

Max length	8
Median length	5
Mean length	2.708557289
Min length	1

Characters and Unicode

Total characters	7506948
Distinct characters	22
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	SW
2nd row	Calm
3rd row	Calm
4th row	Calm
5th row	WSW

Common Values

Value	Count	Frequency (%)
CALM	433622	15.2%
S	169743	6.0%
W	167830	5.9%
WNW	145046	5.1%
NW	141344	5.0%
SSW	137282	4.8%
WSW	130734	4.6%
SW	128970	4.5%
SSE	125516	4.4%
NNW	124583	4.4%
Other values (14)	1066897	37.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
calm	510156	18.4%
s	169743	6.1%
w	167830	6.1%
wnw	145046	5.2%
nw	141344	5.1%
ssw	137282	5.0%
wsw	130734	4.7%
sw	128970	4.7%
sse	125516	4.5%
nnw	124583	4.5%
Other values (13)	990363	35.7%

Most occurring characters

Value	Count	Frequency (%)
W	1290808	17.2%
S	1206342	16.1%
N	1046938	13.9%
E	950572	12.7%
A	537804	7.2%
C	510156	6.8%
L	433622	5.8%
M	433622	5.8%
a	144111	1.9%
t	135911	1.8%
Other values (12)	817062	10.9%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	6640457	88.5%
Lowercase Letter	866491	11.5%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	144111	16.6%
t	135911	15.7%
l	98763	11.4%
m	76534	8.8%
o	73553	8.5%
h	73553	8.5%
s	62358	7.2%
e	61468	7.1%
r	56607	6.5%
u	39175	4.5%
Other values (2)	44458	5.1%

Uppercase Letter

Value	Count	Frequency (%)
W	1290808	19.4%
S	1206342	18.2%
N	1046938	15.8%
E	950572	14.3%
A	537804	8.1%
C	510156	7.7%
L	433622	6.5%
M	433622	6.5%
V	126411	1.9%
R	104182	1.6%

Most occurring scripts

Value	Count	Frequency (%)
Latin	7506948	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
W	1290808	17.2%
S	1206342	16.1%
N	1046938	13.9%
E	950572	12.7%
A	537804	7.2%
C	510156	6.8%
L	433622	5.8%
M	433622	5.8%
a	144111	1.9%
t	135911	1.8%
Other values (12)	817062	10.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	7506948	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
W	1290808	17.2%
S	1206342	16.1%
N	1046938	13.9%
E	950572	12.7%
A	537804	7.2%
C	510156	6.8%
L	433622	5.8%
M	433622	5.8%
a	144111	1.9%
t	135911	1.8%
Other values (12)	817062	10.9%

Wind_Speed(mph)
Real number (ℝ_≥0)

MISSING
ZEROS

Distinct	136
Distinct (%)	< 0.1%
Missing	157944
Missing (%)	5.6%
Infinite	0
Infinite (%)	0.0%
Mean	7.395044203

Minimum	0
Maximum	1087
Zeros	433636
Zeros (%)	15.2%
Negative	0
Negative (%)	0.0%
Memory size	21.7 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	3.5
median	7
Q3	10
95-th percentile	17
Maximum	1087
Range	1087
Interquartile range (IQR)	6.5

Descriptive statistics

Standard deviation	5.52745395
Coefficient of variation (CV)	0.7474538081
Kurtosis	1508.031366
Mean	7.395044203
Median Absolute Deviation (MAD)	3
Skewness	10.24972664
Sum	19873427
Variance	30.55274717
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	433636	15.2%
5	231000	8.1%
3	225664	7.9%
6	222502	7.8%
7	205667	7.2%
8	184037	6.5%
9	165127	5.8%
10	135850	4.8%
12	117003	4.1%
13	88872	3.1%
Other values (126)	678040	23.8%
(Missing)	157944	5.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	433636	15.2%
1	58	< 0.1%
1.2	116	< 0.1%
2	150	< 0.1%
2.3	251	< 0.1%
3	225664	7.9%
3.5	42429	1.5%
4.6	44989	1.6%
5	231000	8.1%
5.8	45427	1.6%

Value	Count	Frequency (%)
1087	1	< 0.1%
984	1	< 0.1%
822.8	2	< 0.1%
812	1	< 0.1%
518	2	< 0.1%
471.8	1	< 0.1%
245.1	1	< 0.1%
243	1	< 0.1%
232	1	< 0.1%
211	1	< 0.1%

Precipitation(in)
Real number (ℝ_≥0)

MISSING
SKEWED
ZEROS

Distinct	230
Distinct (%)	< 0.1%
Missing	549458
Missing (%)	19.3%
Infinite	0
Infinite (%)	0.0%
Mean	0.00701693988

Minimum	0
Maximum	24
Zeros	2104242
Zeros (%)	74.0%
Negative	0
Negative (%)	0.0%
Memory size	21.7 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0.02
Maximum	24
Range	24
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.09348831171
Coefficient of variation (CV)	13.32323111
Kurtosis	16665.25623
Mean	0.00701693988
Median Absolute Deviation (MAD)	0
Skewness	106.2589449
Sum	16110.08
Variance	0.008740064427
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2104242	74.0%
0.01	54160	1.9%
0.02	26497	0.9%
0.03	17786	0.6%
0.04	13745	0.5%
0.05	10563	0.4%
0.06	8575	0.3%
0.07	6868	0.2%
0.08	5942	0.2%
0.09	5303	0.2%
Other values (220)	42203	1.5%
(Missing)	549458	19.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2104242	74.0%
0.01	54160	1.9%
0.02	26497	0.9%
0.03	17786	0.6%
0.04	13745	0.5%
0.05	10563	0.4%
0.06	8575	0.3%
0.07	6868	0.2%
0.08	5942	0.2%
0.09	5303	0.2%

Value	Count	Frequency (%)
24	5	< 0.1%
10.4	2	< 0.1%
10.05	1	< 0.1%
10.02	3	< 0.1%
10.01	1	< 0.1%
10	15	< 0.1%
9.99	50	< 0.1%
9.98	10	< 0.1%
9.97	9	< 0.1%
9.96	11	< 0.1%

Weather_Condition
Categorical

HIGH CARDINALITY
MISSING

Distinct	127
Distinct (%)	< 0.1%
Missing	70636
Missing (%)	2.5%
Memory size	21.7 MiB

Fair	1107194
Mostly Cloudy	363959
Cloudy	348767
Partly Cloudy	249939
Clear	173823
Other values (122)	531024

Length

Max length	35
Median length	30
Mean length	7.381590338
Min length	3

Characters and Unicode

Total characters	20481743
Distinct characters	46
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	16 ?
Unique (%)	< 0.1%

Sample

1st row	Light Rain
2nd row	Light Rain
3rd row	Overcast
4th row	Overcast
5th row	Light Rain

Common Values

Value	Count	Frequency (%)
Fair	1107194	38.9%
Mostly Cloudy	363959	12.8%
Cloudy	348767	12.3%
Partly Cloudy	249939	8.8%
Clear	173823	6.1%
Light Rain	128403	4.5%
Overcast	84882	3.0%
Scattered Clouds	45132	1.6%
Light Snow	43752	1.5%
Fog	41226	1.4%
Other values (117)	187629	6.6%
(Missing)	70636	2.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
fair	1122389	29.6%
cloudy	979677	25.8%
mostly	370256	9.8%
partly	253815	6.7%
light	193371	5.1%
rain	185128	4.9%
clear	173823	4.6%
overcast	84882	2.2%
snow	53748	1.4%
scattered	45132	1.2%
Other values (51)	328144	8.7%

Most occurring characters

Value	Count	Frequency (%)
a	1926734	9.4%
l	1835427	9.0%
r	1732864	8.5%
y	1676635	8.2%
i	1603157	7.8%
o	1518576	7.4%
C	1198634	5.9%
F	1168184	5.7%
d	1136664	5.5%
u	1046822	5.1%
Other values (36)	5638046	27.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	15675963	76.5%
Uppercase Letter	3735727	18.2%
Space Separator	1015659	5.0%
Other Punctuation	43608	0.2%
Dash Punctuation	10786	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	1926734	12.3%
l	1835427	11.7%
r	1732864	11.1%
y	1676635	10.7%
i	1603157	10.2%
o	1518576	9.7%
d	1136664	7.3%
u	1046822	6.7%
t	1035948	6.6%
s	508898	3.2%
Other values (15)	1654238	10.6%

Uppercase Letter

Value	Count	Frequency (%)
C	1198634	32.1%
F	1168184	31.3%
M	375193	10.0%
P	256084	6.9%
L	193372	5.2%
R	185128	5.0%
S	119203	3.2%
O	84882	2.3%
H	55817	1.5%
W	46515	1.2%
Other values (8)	52715	1.4%

Space Separator

Value	Count	Frequency (%)
	1015659	100.0%

Other Punctuation

Value	Count	Frequency (%)
/	43608	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	10786	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	19411690	94.8%
Common	1070053	5.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	1926734	9.9%
l	1835427	9.5%
r	1732864	8.9%
y	1676635	8.6%
i	1603157	8.3%
o	1518576	7.8%
C	1198634	6.2%
F	1168184	6.0%
d	1136664	5.9%
u	1046822	5.4%
Other values (33)	4567993	23.5%

Common

Value	Count	Frequency (%)
	1015659	94.9%
/	43608	4.1%
-	10786	1.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	20481743	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	1926734	9.4%
l	1835427	9.0%
r	1732864	8.5%
y	1676635	8.2%
i	1603157	7.8%
o	1518576	7.4%
C	1198634	5.9%
F	1168184	5.7%
d	1136664	5.5%
u	1046822	5.1%
Other values (36)	5638046	27.5%

Amenity
Boolean

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.7 MiB

False	2817352
True	27990

Common Values
Category Frequency Plot

Value	Count	Frequency (%)
False	2817352	99.0%
True	27990	1.0%

Bump
Boolean

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.7 MiB

False	2844321
True	1021

Common Values
Category Frequency Plot

Value	Count	Frequency (%)
False	2844321	> 99.9%
True	1021	< 0.1%

Crossing
Boolean

HIGH CORRELATION
HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.7 MiB

False	2645130
True	200212

Common Values
Category Frequency Plot

Value	Count	Frequency (%)
False	2645130	93.0%
True	200212	7.0%

Give_Way
Boolean

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.7 MiB

False	2838474
True	6868

Common Values
Category Frequency Plot

Value	Count	Frequency (%)
False	2838474	99.8%
True	6868	0.2%

Junction
Boolean

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.7 MiB

False	2554837
True	290505

Common Values
Category Frequency Plot

Value	Count	Frequency (%)
False	2554837	89.8%
True	290505	10.2%

No_Exit
Boolean

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.7 MiB

False	2841048
True	4294

Common Values
Category Frequency Plot

Value	Count	Frequency (%)
False	2841048	99.8%
True	4294	0.2%

Railway
Boolean

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.7 MiB

False	2822711
True	22631

Common Values
Category Frequency Plot

Value	Count	Frequency (%)
False	2822711	99.2%
True	22631	0.8%

Roundabout
Boolean

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.7 MiB

False	2845219
True	123

Common Values
Category Frequency Plot

Value	Count	Frequency (%)
False	2845219	> 99.9%
True	123	< 0.1%

Station
Boolean

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.7 MiB

False	2777347
True	67995

Common Values
Category Frequency Plot

Value	Count	Frequency (%)
False	2777347	97.6%
True	67995	2.4%

Stop
Boolean

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.7 MiB

False	2794942
True	50400

Common Values
Category Frequency Plot

Value	Count	Frequency (%)
False	2794942	98.2%
True	50400	1.8%

Traffic_Calming
Boolean

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.7 MiB

False	2843630
True	1712

Common Values
Category Frequency Plot

Value	Count	Frequency (%)
False	2843630	99.9%
True	1712	0.1%

Traffic_Signal
Boolean

HIGH CORRELATION
HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.7 MiB

False	2580079
True	265263

Common Values
Category Frequency Plot

Value	Count	Frequency (%)
False	2580079	90.7%
True	265263	9.3%

Turning_Loop
Boolean

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	2.7 MiB

False	2845342

Common Values
Category Frequency Plot

Value	Count	Frequency (%)
False	2845342	100.0%

Sunrise_Sunset
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	2867
Missing (%)	0.1%
Memory size	21.7 MiB

Day	1811935
Night	1030540

Length

Max length	5
Median length	3
Mean length	3.725100485
Min length	3

Characters and Unicode

Total characters	10588505
Distinct characters	8
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Night
2nd row	Night
3rd row	Night
4th row	Night
5th row	Day

Common Values

Value	Count	Frequency (%)
Day	1811935	63.7%
Night	1030540	36.2%
(Missing)	2867	0.1%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
day	1811935	63.7%
night	1030540	36.3%

Most occurring characters

Value	Count	Frequency (%)
D	1811935	17.1%
a	1811935	17.1%
y	1811935	17.1%
N	1030540	9.7%
i	1030540	9.7%
g	1030540	9.7%
h	1030540	9.7%
t	1030540	9.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	7746030	73.2%
Uppercase Letter	2842475	26.8%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	1811935	23.4%
y	1811935	23.4%
i	1030540	13.3%
g	1030540	13.3%
h	1030540	13.3%
t	1030540	13.3%

Uppercase Letter

Value	Count	Frequency (%)
D	1811935	63.7%
N	1030540	36.3%

Most occurring scripts

Value	Count	Frequency (%)
Latin	10588505	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
D	1811935	17.1%
a	1811935	17.1%
y	1811935	17.1%
N	1030540	9.7%
i	1030540	9.7%
g	1030540	9.7%
h	1030540	9.7%
t	1030540	9.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	10588505	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
D	1811935	17.1%
a	1811935	17.1%
y	1811935	17.1%
N	1030540	9.7%
i	1030540	9.7%
g	1030540	9.7%
h	1030540	9.7%
t	1030540	9.7%

Civil_Twilight
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	2867
Missing (%)	0.1%
Memory size	21.7 MiB

Day	1929103
Night	913372

Length

Max length	5
Median length	3
Mean length	3.642659654
Min length	3

Characters and Unicode

Total characters	10354169
Distinct characters	8
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Night
2nd row	Night
3rd row	Night
4th row	Night
5th row	Day

Common Values

Value	Count	Frequency (%)
Day	1929103	67.8%
Night	913372	32.1%
(Missing)	2867	0.1%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
day	1929103	67.9%
night	913372	32.1%

Most occurring characters

Value	Count	Frequency (%)
D	1929103	18.6%
a	1929103	18.6%
y	1929103	18.6%
N	913372	8.8%
i	913372	8.8%
g	913372	8.8%
h	913372	8.8%
t	913372	8.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	7511694	72.5%
Uppercase Letter	2842475	27.5%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	1929103	25.7%
y	1929103	25.7%
i	913372	12.2%
g	913372	12.2%
h	913372	12.2%
t	913372	12.2%

Uppercase Letter

Value	Count	Frequency (%)
D	1929103	67.9%
N	913372	32.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	10354169	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
D	1929103	18.6%
a	1929103	18.6%
y	1929103	18.6%
N	913372	8.8%
i	913372	8.8%
g	913372	8.8%
h	913372	8.8%
t	913372	8.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	10354169	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
D	1929103	18.6%
a	1929103	18.6%
y	1929103	18.6%
N	913372	8.8%
i	913372	8.8%
g	913372	8.8%
h	913372	8.8%
t	913372	8.8%

Nautical_Twilight
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	2867
Missing (%)	0.1%
Memory size	21.7 MiB

Day	2063472
Night	779003

Length

Max length	5
Median length	3
Mean length	3.54811599
Min length	3

Characters and Unicode

Total characters	10085431
Distinct characters	8
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Night
2nd row	Night
3rd row	Night
4th row	Day
5th row	Day

Common Values

Value	Count	Frequency (%)
Day	2063472	72.5%
Night	779003	27.4%
(Missing)	2867	0.1%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
day	2063472	72.6%
night	779003	27.4%

Most occurring characters

Value	Count	Frequency (%)
D	2063472	20.5%
a	2063472	20.5%
y	2063472	20.5%
N	779003	7.7%
i	779003	7.7%
g	779003	7.7%
h	779003	7.7%
t	779003	7.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	7242956	71.8%
Uppercase Letter	2842475	28.2%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	2063472	28.5%
y	2063472	28.5%
i	779003	10.8%
g	779003	10.8%
h	779003	10.8%
t	779003	10.8%

Uppercase Letter

Value	Count	Frequency (%)
D	2063472	72.6%
N	779003	27.4%

Most occurring scripts

Value	Count	Frequency (%)
Latin	10085431	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
D	2063472	20.5%
a	2063472	20.5%
y	2063472	20.5%
N	779003	7.7%
i	779003	7.7%
g	779003	7.7%
h	779003	7.7%
t	779003	7.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	10085431	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
D	2063472	20.5%
a	2063472	20.5%
y	2063472	20.5%
N	779003	7.7%
i	779003	7.7%
g	779003	7.7%
h	779003	7.7%
t	779003	7.7%

Astronomical_Twilight
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	2867
Missing (%)	0.1%
Memory size	21.7 MiB

Day	2176983
Night	665492

Length

Max length	5
Median length	3
Mean length	3.46824827
Min length	3

Characters and Unicode

Total characters	9858409
Distinct characters	8
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Night
2nd row	Night
3rd row	Day
4th row	Day
5th row	Day

Common Values

Value	Count	Frequency (%)
Day	2176983	76.5%
Night	665492	23.4%
(Missing)	2867	0.1%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
day	2176983	76.6%
night	665492	23.4%

Most occurring characters

Value	Count	Frequency (%)
D	2176983	22.1%
a	2176983	22.1%
y	2176983	22.1%
N	665492	6.8%
i	665492	6.8%
g	665492	6.8%
h	665492	6.8%
t	665492	6.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	7015934	71.2%
Uppercase Letter	2842475	28.8%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	2176983	31.0%
y	2176983	31.0%
i	665492	9.5%
g	665492	9.5%
h	665492	9.5%
t	665492	9.5%

Uppercase Letter

Value	Count	Frequency (%)
D	2176983	76.6%
N	665492	23.4%

Most occurring scripts

Value	Count	Frequency (%)
Latin	9858409	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
D	2176983	22.1%
a	2176983	22.1%
y	2176983	22.1%
N	665492	6.8%
i	665492	6.8%
g	665492	6.8%
h	665492	6.8%
t	665492	6.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	9858409	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
D	2176983	22.1%
a	2176983	22.1%
y	2176983	22.1%
N	665492	6.8%
i	665492	6.8%
g	665492	6.8%
h	665492	6.8%
t	665492	6.8%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	ID	Severity	Start_Time	End_Time	Start_Lat	Start_Lng	End_Lat	End_Lng	Distance(mi)	Description	Number	Street	Side	City	County	State	Zipcode	Country	Timezone	Airport_Code	Weather_Timestamp	Temperature(F)	Wind_Chill(F)	Humidity(%)	Pressure(in)	Visibility(mi)	Wind_Direction	Wind_Speed(mph)	Precipitation(in)	Weather_Condition	Amenity	Bump	Crossing	Give_Way	Junction	No_Exit	Railway	Roundabout	Station	Stop	Traffic_Calming	Traffic_Signal	Turning_Loop	Sunrise_Sunset	Civil_Twilight	Nautical_Twilight	Astronomical_Twilight
0	A-1	3	2016-02-08 00:37:08	2016-02-08 06:37:08	40.108910	-83.092860	40.112060	-83.031870	3.230	Between Sawmill Rd/Exit 20 and OH-315/Olentangy Riv Rd/Exit 22 - Accident.	NaN	Outerbelt E	R	Dublin	Franklin	OH	43017	US	US/Eastern	KOSU	2016-02-08 00:53:00	42.1	36.1	58.0	29.76	10.0	SW	10.4	0.00	Light Rain	False	False	False	False	False	False	False	False	False	False	False	False	False	Night	Night	Night	Night
1	A-2	2	2016-02-08 05:56:20	2016-02-08 11:56:20	39.865420	-84.062800	39.865010	-84.048730	0.747	At OH-4/OH-235/Exit 41 - Accident.	NaN	I-70 E	R	Dayton	Montgomery	OH	45424	US	US/Eastern	KFFO	2016-02-08 05:58:00	36.9	NaN	91.0	29.68	10.0	Calm	NaN	0.02	Light Rain	False	False	False	False	False	False	False	False	False	False	False	False	False	Night	Night	Night	Night
2	A-3	2	2016-02-08 06:15:39	2016-02-08 12:15:39	39.102660	-84.524680	39.102090	-84.523960	0.055	At I-71/US-50/Exit 1 - Accident.	NaN	I-75 S	R	Cincinnati	Hamilton	OH	45203	US	US/Eastern	KLUK	2016-02-08 05:53:00	36.0	NaN	97.0	29.70	10.0	Calm	NaN	0.02	Overcast	False	False	False	False	True	False	False	False	False	False	False	False	False	Night	Night	Night	Day
3	A-4	2	2016-02-08 06:51:45	2016-02-08 12:51:45	41.062130	-81.537840	41.062170	-81.535470	0.123	At Dart Ave/Exit 21 - Accident.	NaN	I-77 N	R	Akron	Summit	OH	44311	US	US/Eastern	KAKR	2016-02-08 06:54:00	39.0	NaN	55.0	29.65	10.0	Calm	NaN	NaN	Overcast	False	False	False	False	False	False	False	False	False	False	False	False	False	Night	Night	Day	Day
4	A-5	3	2016-02-08 07:53:43	2016-02-08 13:53:43	39.172393	-84.492792	39.170476	-84.501798	0.500	At Mitchell Ave/Exit 6 - Accident.	NaN	I-75 S	R	Cincinnati	Hamilton	OH	45217	US	US/Eastern	KLUK	2016-02-08 07:53:00	37.0	29.8	93.0	29.69	10.0	WSW	10.4	0.01	Light Rain	False	False	False	False	False	False	False	False	False	False	False	False	False	Day	Day	Day	Day
5	A-6	2	2016-02-08 08:16:57	2016-02-08 14:16:57	39.063240	-84.032430	39.067310	-84.058510	1.427	At Dela Palma Rd - Accident.	NaN	State Route 32	R	Williamsburg	Clermont	OH	45176	US	US/Eastern	KI69	2016-02-08 08:16:00	35.6	29.2	100.0	29.66	10.0	WSW	8.1	NaN	Overcast	False	False	False	False	False	False	False	False	False	False	False	True	False	Day	Day	Day	Day
6	A-7	2	2016-02-08 08:15:41	2016-02-08 14:15:41	39.775650	-84.186030	39.772750	-84.188050	0.227	At OH-4/Exit 54 - Accident.	NaN	I-75 S	R	Dayton	Montgomery	OH	45404	US	US/Eastern	KFFO	2016-02-08 08:18:00	33.8	NaN	100.0	29.63	3.0	SW	2.3	NaN	Mostly Cloudy	False	False	False	False	False	False	False	False	False	False	False	False	False	Day	Day	Day	Day
7	A-8	2	2016-02-08 11:51:46	2016-02-08 17:51:46	41.375310	-81.820170	41.367860	-81.821740	0.521	At Bagley Rd/Exit 235 - Accident.	NaN	I-71 S	R	Cleveland	Cuyahoga	OH	44130	US	US/Eastern	KCLE	2016-02-08 11:51:00	33.1	30.0	92.0	29.63	0.5	SW	3.5	0.08	Snow	False	False	False	False	True	False	False	False	False	False	False	False	False	Day	Day	Day	Day
8	A-9	2	2016-02-08 14:19:57	2016-02-08 20:19:57	40.702247	-84.075887	40.699110	-84.084293	0.491	At OH-65/Exit 122 - Accident.	NaN	E Hanthorn Rd	R	Lima	Allen	OH	45806	US	US/Eastern	KAOH	2016-02-08 13:53:00	39.0	31.8	70.0	29.59	10.0	WNW	11.5	NaN	Overcast	False	False	False	False	False	False	False	False	False	False	False	False	False	Day	Day	Day	Day
9	A-10	2	2016-02-08 15:16:43	2016-02-08 21:16:43	40.109310	-82.968490	40.110780	-82.984000	0.826	At I-71/Exit 26 - Accident.	NaN	Outerbelt W	R	Westerville	Franklin	OH	43081	US	US/Eastern	KCMH	2016-02-08 15:12:00	32.0	28.7	100.0	29.59	0.5	West	3.5	0.05	Snow	False	False	False	False	False	False	False	False	False	False	False	False	False	Day	Day	Day	Day

Last rows

	ID	Severity	Start_Time	End_Time	Start_Lat	Start_Lng	End_Lat	End_Lng	Distance(mi)	Description	Number	Street	Side	City	County	State	Zipcode	Country	Timezone	Airport_Code	Weather_Timestamp	Temperature(F)	Wind_Chill(F)	Humidity(%)	Pressure(in)	Visibility(mi)	Wind_Direction	Wind_Speed(mph)	Precipitation(in)	Weather_Condition	Amenity	Bump	Crossing	Give_Way	Junction	No_Exit	Railway	Roundabout	Station	Stop	Traffic_Calming	Traffic_Signal	Turning_Loop	Sunrise_Sunset	Civil_Twilight	Nautical_Twilight	Astronomical_Twilight
2845332	A-2845333	2	2019-08-23 17:42:27	2019-08-23 18:11:10	34.064460	-118.003880	34.065330	-117.997150	0.390	At I-605 - Accident.	NaN	I-10 E	R	Baldwin Park	Los Angeles	CA	91706	US	US/Pacific	KEMT	2019-08-23 17:53:00	78.0	78.0	52.0	29.69	10.0	VAR	6.0	0.0	Fair	False	False	False	False	False	False	False	False	False	False	False	False	False	Day	Day	Day	Day
2845333	A-2845334	2	2019-08-23 17:40:12	2019-08-23 18:08:35	33.943599	-117.077880	33.943599	-117.077880	0.000	At Jack Rabbit Trl - Accident.	NaN	CA-60 E	R	Moreno Valley	Riverside	CA	92555	US	US/Pacific	KRIV	2019-08-23 17:58:00	88.0	88.0	32.0	28.20	10.0	WNW	10.0	0.0	Fair	False	False	False	False	False	False	False	False	False	False	False	False	False	Day	Day	Day	Day
2845334	A-2845335	2	2019-08-23 17:40:12	2019-08-23 18:08:35	34.261030	-119.228000	34.262390	-119.230870	0.189	At Telephone Rd/Exit 65 - Accident.	NaN	El Camino Real N	R	Ventura	Ventura	CA	93003	US	US/Pacific	KOXR	2019-08-23 17:51:00	73.0	73.0	68.0	29.76	10.0	W	9.0	0.0	Fair	False	False	False	False	True	False	False	False	False	False	False	False	False	Day	Day	Day	Day
2845335	A-2845336	2	2019-08-23 17:43:56	2019-08-23 18:12:27	33.741700	-117.837090	33.739170	-117.830010	0.443	At CA-55 - Accident.	NaN	Santa Ana Fwy S	R	Tustin	Orange	CA	92780	US	US/Pacific	KSNA	2019-08-23 17:53:00	75.0	75.0	60.0	29.74	10.0	SSW	9.0	0.0	Fair	False	False	False	False	False	False	False	False	False	False	False	False	False	Day	Day	Day	Day
2845336	A-2845337	2	2019-08-23 18:30:23	2019-08-23 18:58:54	34.239104	-118.416176	34.239104	-118.416176	0.000	At Osborne St/Exit 154 - Accident.	NaN	Golden State Fwy N	R	Pacoima	Los Angeles	CA	91331	US	US/Pacific	KWHP	2019-08-23 18:50:00	81.0	81.0	48.0	28.78	10.0	ESE	6.0	NaN	Fair	False	False	False	False	False	False	False	False	False	False	False	False	False	Day	Day	Day	Day
2845337	A-2845338	2	2019-08-23 18:03:25	2019-08-23 18:32:01	34.002480	-117.379360	33.998880	-117.370940	0.543	At Market St - Accident.	NaN	Pomona Fwy E	R	Riverside	Riverside	CA	92501	US	US/Pacific	KRAL	2019-08-23 17:53:00	86.0	86.0	40.0	28.92	10.0	W	13.0	0.0	Fair	False	False	False	False	False	False	False	False	False	False	False	False	False	Day	Day	Day	Day
2845338	A-2845339	2	2019-08-23 19:11:30	2019-08-23 19:38:23	32.766960	-117.148060	32.765550	-117.153630	0.338	At Camino Del Rio/Mission Center Rd - Accident.	NaN	I-8 W	R	San Diego	San Diego	CA	92108	US	US/Pacific	KMYF	2019-08-23 18:53:00	70.0	70.0	73.0	29.39	10.0	SW	6.0	0.0	Fair	False	False	False	False	False	False	False	False	False	False	False	False	False	Day	Day	Day	Day
2845339	A-2845340	2	2019-08-23 19:00:21	2019-08-23 19:28:49	33.775450	-117.847790	33.777400	-117.857270	0.561	At Glassell St/Grand Ave - Accident. in the right lane.	NaN	Garden Grove Fwy	R	Orange	Orange	CA	92866	US	US/Pacific	KSNA	2019-08-23 18:53:00	73.0	73.0	64.0	29.74	10.0	SSW	10.0	0.0	Partly Cloudy	False	False	False	False	True	False	False	False	False	False	False	False	False	Day	Day	Day	Day
2845340	A-2845341	2	2019-08-23 19:00:21	2019-08-23 19:29:42	33.992460	-118.403020	33.983110	-118.395650	0.772	At CA-90/Marina Fwy/Jefferson Blvd - Accident.	NaN	San Diego Fwy S	R	Culver City	Los Angeles	CA	90230	US	US/Pacific	KSMO	2019-08-23 18:51:00	71.0	71.0	81.0	29.62	10.0	SW	8.0	0.0	Fair	False	False	False	False	False	False	False	False	False	False	False	False	False	Day	Day	Day	Day
2845341	A-2845342	2	2019-08-23 18:52:06	2019-08-23 19:21:31	34.133930	-117.230920	34.137360	-117.239340	0.537	At Highland Ave/Arden Ave - Accident.	NaN	CA-210 W	R	Highland	San Bernardino	CA	92346	US	US/Pacific	KSBD	2019-08-23 20:50:00	79.0	79.0	47.0	28.63	7.0	SW	7.0	0.0	Fair	False	False	False	False	False	False	False	False	False	False	False	False	False	Day	Day	Day	Day

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Uppercase Letter

Dash Punctuation

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Dash Punctuation

Space Separator

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Dash Punctuation

Space Separator

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Other Punctuation

Decimal Number

Open Punctuation

Close Punctuation

Math Symbol

Space Separator

Modifier Symbol

Dash Punctuation

Control

Connector Punctuation

Currency Symbol

Final Punctuation

Other Symbol